Question

Need to establish the number of days between a given future date and today's date.  It's currently a pre-requisite for a set of business rules to kick in.  Haven't had any luck in finding a DATE function that I can use.

PrevContributor · Accepted Answer

There isn't one, unfortunately.
You can up vote the request for enhancement and hope it gets brought in:

https://community.anaplan.com/forums/-/message_boards/message/2908476

PrevContributor · Accepted Answer

[quote=Dino Sanchez]Has anyone figured out how to do this? I currentyl am doing work for a client and they need to count their daily interest rate versus their maturity date. Still have not figured out how I can do this, having a today() function helps me do this.[/quote]I have setup an assumptions module with an item "Today's date" with date being the format. I have linked formulas to that item and on a dashboard I manually change the date, when I need reports. Not ideal but works.

When I get around to learning/investigating Anaplan connect, I would either use a database system date or an excel file with Today() in it, auto update the above table at 00:01, each day.  If someone does this automation, please post back.

Hope that is of assistance.

Regards
Devin