Is there a formula to get the current date?

Ana22

Hi,

Thanks,
Ana

Accepted answers

Manuela_Apostol

Hi @Ana22 ,

At the moment there is no equivalent in Anaplan with the NOW() function as in Excel.

What you can do, however, is to set up a daily import via Anaplan Connect to have a daily update.

I have seen an idea posted on the community. I also think it will be very useful, but so far there is only the workaround with Anaplan Connect (or manual daily entry).

This is the thread, but it needs community support: https://community.anaplan.com/t5/Idea-Exchange/Current-Date-and-Time/idi-p/46550

Kind regards,
Manuela

All comments

Manuela_Apostol

Hi @Ana22 ,

At the moment there is no equivalent in Anaplan with the NOW() function as in Excel.

What you can do, however, is to set up a daily import via Anaplan Connect to have a daily update.

I have seen an idea posted on the community. I also think it will be very useful, but so far there is only the workaround with Anaplan Connect (or manual daily entry).

This is the thread, but it needs community support: https://community.anaplan.com/t5/Idea-Exchange/Current-Date-and-Time/idi-p/46550

Kind regards,
Manuela

Ana22

Thanks @Manuela_Apostol 🙂

Quick Links

Can you help?

Unanswered questions

Best way to Architect Financial Statements in Anaplan for Scalability
I have seen two methods used to build financial statements and I am wondering what others have experienced in scalability/maintenance between the two or if there is a better approach. Assume that we have a flat data source for our general ledger within Anaplan. Our line item we are focused on within the source data is the…
Curious Comparison: Forecast Modeling for Unusual Products
I've been experimenting with some forecast modeling techniques in Anaplan recently and decided to test them on a few quirky, offbeat product categories just for fun. One of the categories I played around with was love dolls—yes, you read that right. It actually turned out to be more interesting than expected. Unlike…
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