Previous Contributor

Today's Date

Hi, How can i refer Today's Date in a formula so as the values would change every day based on that days date. For e.g. if its 09th june then the formula should give result as 09th june . The next day i.e. 10th june the value should get updated to 10th june. Is there any such functionality or formula available inside Anaplan. Please let me know ThankYou

12 REPLIES 12
Community Manager

RE: Today's Date

Pavan, There is a script available through Anaplan Connect that will allow the import of today's date into the model. This is the only way that the date can be updated throughout the model. There are no formulas that will enable that function to automatically happen. If you are interested in that script, please let me know and I can get that to you. Thank you! Emily
New Contributor

Re: RE: Today's Date

Can i have the script?thanks!

Regular Contributor

Re: RE: Today's Date

Could i have a copy of the script please. I have one currently but it is not reliable.

 

Thank you

 

Community Manager

Re: RE: Today's Date

@kfizz@DeveloperCYT@lmuladore@bradley.sisson, and @Agandhi - I think I finally have what you might be looking for.

 

Attached is a Shell script that was recently tested for updating a current date. Let us know how this works out for you.

 

Special thanks to @greg_kajewski and @alec_judd!

Frequent Contributor

Re: RE: Today's Date

Hi Emily,

 

Do you have the .bat version instead of .sh?

 

Thanks.

Leo

Community Manager

Re: RE: Today's Date

@alec_judd or @greg_kajewski - See Leo's question, please. Do you have a .bat available?

Contributor

Re: RE: Today's Date

Hi Leo, 

Here's the script that I've used that is setup to run as a .bat file. You'll need to just rename the .txt to .bat to convert it back. 


Frequent Contributor

Re: RE: Today's Date

Thanks Greg!

Highlighted
Occasional Contributor

Re: RE: Today's Date

Hi @greg_kajewski!

 

Thanks for the .bat file.

I have a question to get it running though:

It says to customize the following directory:

This variable AC_exe should be set to the path of the AnaplanClient.bat
set AC_exe=D:\Anaplan\AnaplanClient.bat

but since Anaplan models are running completely web-based and there is no local client running I do not see how I can access this path. I have not a lot of technical know-how on how these things work, but if you could clarify a little it would be very helpful.