Today() Function

I'm wondering why in Anaplan we can only have to input current period in Time.

As we're using Anaplan as Supply Chain planification tools and we work really at planning on days level.

So it's necessary for us to determine "today"'s date.

The solution we use now is to launch an automatic import and update the "Today" item.

It might be much more convenient if we can have a formular Today() like in Excel to know automatically the current date.

I suppose the difficulty might be the different time zones so it might be even nicer to have an option to choose the time zone in the formular like this today(Time_Zone).

Thank you,

Best regards

Comments

Phil11

I'd like the 'Today' function and I'd also like to be able to use it as a date stamp (so I don't want it to update once it has generated), e.g. so I can see when User A submitted their plan as part of the workflow.

I'm happy to be shown how this might already be possible by the way!

jprince

Anaplan has timestamps built into the history, we should be able to pull in the date and time for UTC!

Bangaltar112

I support this idea ! I don't understand why the timestamp from the history is not retrievable with a formula in a line item.

It would be very usefull to time stamp entries in an input form for example.

wwood

Another vote for this functionality

jakesachs

Another vote for this!

gsmerilli

Another vote for this , It is really valuable to have in some UX Dashboards some time stamps of actions.

philip.austin

Hi Product team, I understand and respect that other solution dependencies impacted the timing of developing this. I know you will address this when it is possible to do so. Yes, there are work-arounds to this requirement but when customers have many models these work arounds often involve numerous integrations and can be onerous. Thank you for keeping this requirement at top-of-mind.

Antonio_Flor

Hi,

the workaround I found was to use CloudWorks and a few lines of code to create an Anaplan timestamp, the build was:

An "input line item" (no formula)
A "Formula line time" saying = if =12 then 1 else "input line item" + 1
An action to copy from "Formula line time" to "input line item"
A CludWorks integration schduled on the hour to run action 3.

I've been testing it for a week and so far the results are good, with accuracy to the hour.

jakesachs

@Antonio_Flor definitely a nice idea but ultimately we need an accurate clock from Anaplan, which should not be hard. We have experienced a bit of cloudworks inconsistency and if there is an error it will break this functionality you built.

Antonio_Flor

Hi @jakesachs ,

This is the reasoning I have in my head for this not to be so straight forward as it seems. I can see several reasons why Anaplan still hasn’t a Now() or Today() function, but they would fall mainly under these 2 in my point of view:

Calculation engine and Granulometry of data

Should the Now() be milliseconds, minutes, or days. How would a module cope with a formula that is constantly changing results?

Anaplan recalculates whenever there’s an input and this would be like having a constant input every millisecond, minute, etc…

Concurrent inputs

It is shared platform with concurrent inputs all over the world on different time zones, so today’s () data would be a bit different depending on where you are.

The history record (right click show history) itself has its problems, particularly when the hour changes. I'm in hte UK and a week ago any input would be recorded one hour behind and now it’s with the correct time, this happens because the servers we use are in the Netherlands …. I understand theat it would be very complex to change the clock on a server (an Anaplan one where history is tracked) not sure why isn’t always one hour behind, I thought central Europe adjust to wintertime on the same day…..

In excel, Now(), today(), come from the time on your local machine, it would be different when you take your laptop abroad and that alone can create confusion on any time recorded, with Anaplan that would be multiplied several fold.

I believe Anaplan would come to a compromise by having the concept of Model Time Zone, and come up with some kind of Today() formula with a lot of restrictions, not sure if in the pipeline for implementation soon, but I wold leave them to comment @gazwillott .

CommunityMember127794

@Antonio_Flor

I certainly agree that NOW would not work as a function in Anaplan. However, Anaplan DOES have a UTC timestamp for every change recorded in the history log. A LASTCHANGED or TIMESTAMP function enabling us to leverage that to display the last change timestamp for a particular cell, a row (i.e. all line items in a module), and summarize it to parents and Top Level items would go a long way.

However, TODAY is pretty straightforward. A UTC Today function would be basic improvement, though as you noted, each model would benefit from being able to be assigned a time zone. We accomplish this via a daily import action to our data hub followed by import actions to every one of our spokes which is a bit tedious and requires change requests to our integration team when we put a new model online.

awestphal

Adding my vote here - my "New UX" users would love this feature

VCWinter

Agree.

jakesachs

One of the comments earlier was regarding time zones etc. I don't think it should matter. Anaplan has time already calculating and knows all the time zones bc of the cloudworks scheduler. You should be able to do a simple setting of what time zone and time you want it change.

jziemer

Any updates on this request? This would assist tremendously with some lacking control features.

Misbah

This is absolute shocker that we are still waiting for this one. Two years ago, I was told that it was round the corner - not sure what happened.

Right now we are at the mercy of CloudWorks to import successfully to get us correct Current date. And we know there is a room for a failure here.

We need TODAY() functionality in the Anaplan asap.

P.S: There used to a SPOC who used to moderate these kind of requests/ideas and update the community on Product Team's behalf. I don't see that happening anymore.

jziemer

Agree with @Misbah. We really need this.

Phil11

If you have access to Anaplan Data Orchestrator, there is a simple function that allows you to create a view with the current date and/or time. This view can then be loaded into an Anaplan module. This would not really scale to multiple users (as far as I can see - but happy to be shown otherwise) potentially doing this around the same time (e.g. workflow date stamp into a module), but none the less a way to data stamp today's date in a module.

I still would consider this a workaround however, so I'm still waiting for a Today function, plus a scalable Anaplan date stamp (i.e. not a function) into a module. 😉

Misbah

@Phil11 Why would someone opt for ADO (which is a paid service) just to get the current date in the system when we can achieve that with CWorks which is the free service for enterprise edition license customers. Question was not about the workaround, it was about TODAY() functionality which is very much needed.

Thanks

Miz

Quick Links

New ideas

TEST
TEST TEST TEST
Anaplan XL Freeform - ability to multi-select in filters
In Anaplan XL Freeform, we would like to specify multiple members on dimensions that apply to the whole report (filters, not rows or columns). This is possible in grids but not yet in freeform.
Clarifying Anaplan’s SSO X.509 Certificate Rotation Process
🔐 Understanding the Anaplan X.509 Certificate Rotation Email (Note: This email is sent to Tenant Security Administrators or Tenant Administrators within your Anaplan Tenant) When you receive an email from Anaplan like this: Email Sample: Hi, Your Anaplan Certificate for SSO needs to be rotated by July 16, 2025 (IST) for…