EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB14798: How to create a metric to calculate the number of days between a date attribute and the current date in MicroStrategy Developer 9.4.x - 10.x


Stefan Zepeda

Salesforce Solutions Architect • Strategy


This technical note provides an example of how to calculate the number of days between the current date and a date attribute.

This technical note provides an example of how to calculate the number of days between the current date and a date attribute. For example, using the Strategy Tutorial project, users may want to calculate the number of days between today and the Hire Date. First, a metric calculating the difference between Hire Date and today is created by using the following definition:
 

ka02R000000kcQXQAY_0EM440000002FO8.jpeg

 
Max((CurrentDate() - ))
After adding the metric to the report, it displays the difference in days, as shown below:
 

ka02R000000kcQXQAY_0EM440000002FO7.jpeg

 


Comment

0 comments

Details

Knowledge Article

Published:

April 25, 2017

Last Updated:

April 25, 2017