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.

Welcome!

It looks like you're new here. Sign in or register to get started.
Sign In

Answers

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

     

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

  • 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

Welcome!

It looks like you're new here. Sign in or register to get started.
Sign In