Add a date stamp

Michael.downer
Michael.downer
in Modeling

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.

Tagged:

Answers

  • SandeepB
    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
    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
    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.

    AB

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

Categories