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

Azure blob connection Cloudworks vs ADO
I am trying to connect to Azure blob, the credentials work on cloudworks, but do not work on ADO. Has anyone else experienced this issue?
Berapa nomor Tokopedia?
Tokopedia Menyediakan layanan WhatsApp? Untuk menghubungi layanan Tokopedia melalui (WA)62_08174_9080_16 kamu bisa mengikuti.
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…