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.

Accepted answers

All comments

SandeepB

@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

otalpur

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

ashish.banka

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

bikash

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

Quick Links

Can you help?

Unanswered questions

OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
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.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385