Register

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

Previous Contributor

## 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.

4 REPLIES 4
Previous Contributor

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

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
Previous Contributor

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

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.
Previous Contributor

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

[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
Frequent Contributor

## Re: RE: Any equivalent to the Excel TODAY() function in Anaplan??

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