Get number of days between 2 dates
Summary:
Greetings,
Need your input on switching from on-premise Workforce application to EPM.
We've migrated to Cloud and one of the feature I used quite frequently in Workforce is the macro @JCstDateDiff which provides me the number days elapsed between 2 provided dates. What is the equivalent in Cloud?
Content (required):
Account defined as dynamic calc, called YTD_Exp with member formula
IF("Start_Month" < "End_Month") @JCstDateDiff("Start_Month","End_Month","yyyyMMdd","yyyyMMdd");
...
Version (include the version you are using, if applicable):
on premise 11.1.2.4
Cloud, not sure..
Code Snippet (add any code snippets that support your topic, if applicable):
0