You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Get number of days between 2 dates

edited Apr 16, 2024 6:41PM in Planning 5 comments

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):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!