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.
Tagged:
9
Best Answers
-
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/29084765 -
[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
Devin1
Answers
-
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.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
0
