Any equivalent to the Excel TODAY() function in Anaplan??

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.

Accepted answers

PrevContributor

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

[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

All comments

PrevContributor

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

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.

PrevContributor

leo_tadjudin_1

There's another discussion with sample of .sh and .bat files used to solve this same issue.

https://community.anaplan.com/t5/Formulas-Functions/Today-s-Date/td-p/867

Quick Links

Can you help?

Unanswered questions

Data Integration to Fluence workspace
Hello Everyone, I am seeking guidance on how I could create a workflow process in Fluence consolidation workspace, using the ADO import task. Does anybody know what kind of information I need to fill in these fields? I have watched the ADO training but only explains the data transformation and integration within Anaplan…
Anaplan add-in for Power Point security issue
Hello everyone I am going through an issue with security when logging into Anaplan via power point add-in. I am a workspace administrator and SSO user. But once I installed add-in for power point, I am not able to login. I am using Universal Login (default) connection and it asks for user name and then a password (not…
Pagination in Management Reports Without splitting Parent Blocks
Hi I would like to set up pagination in management reports by assigning a page number to a list item and its parent but I also want to be able to keep a block of parent and list items together and not split over two pages. E.g. Parent 1 - 1 Child 1 - 2 Child 2 - 3 Parent 2 - 4 Child 3 - 5 Child 4 - 6 Child 5 - 7…