Add a date stamp

Highlighted
Occasional Contributor

Add a date stamp

HI All,

 

II need to add a state stamp into a table. My plan is to have a Line item that somehow calculated the current time (equivalent in excel would be NOW()). I then plan to use the Import data to import that date into a static date line item in the same module.

 

Does anyone know how to get Anaplan to show the current date into a line item. (Without me having to choose a date)?

 

Thank you in advance.

4 REPLIES 4
Highlighted
Regular Contributor

Re: Add a date stamp

@Michael.downer,

 

Anaplan doesn't have inbuilt functionality to get the current date similar to NOW() in excel.

However, you can set up a daily import via Anaplan Connect to have a daily update. 

 

few links that could help you, 

 

https://community.anaplan.com/t5/Anaplan-Platform/Today-s-Date/td-p/867

 

https://community.anaplan.com/t5/Idea-Exchange/Current-Date-and-Time/idi-p/46550

 

Thanks,

Sandeep

 

Highlighted
Certified Master Anaplanner

Re: Add a date stamp

Anaplan doesn't have a function to do this. Importing through Anaplan Connect is your best bet unfortunately. This feature has been requested though: https://community.anaplan.com/t5/Idea-Exchange/Current-Date-and-Time/idi-p/46550
Highlighted
Frequent Contributor

Re: Add a date stamp

@Michael.downer  As others had mentioned, Anaplan currently does not provide any function to calculate Current Date / System Date.

 

Although I can understand your need. I would suggest to get a file generated either from any database or from the system on which you would be running the integration tool (Anaplan Connect etc) for automation. Use that file to load into a specific Current Date system module line item to use it across the model.

 

Hope this helps.

AB

Highlighted
Certified Master Anaplanner

Re: Add a date stamp

Hi,

You can probably use the following method: (We have been managing this way for few such scenarios):

Create an import from a VM (server) using Anaplan Connect (batch script) with today's date & time. 

Then, Create a process with the following actions:

1. Today's date import action

2. The import action that you plan to import into another target module

As we understand from Anaplan, TODAY function should be available within 1-2 months. But not sure, if it will have time stamp as well.

 

Hope this helps. 

 

Kind Regards

Bikash