functions

Ayeshazaina · 2023-03-08T19:21:02+00:00

There was an error rendering this rich post.

As anaplan does not have builtin function to give you the current date and time.Can someone tell me the ways to capture the current date

Appreciate your response

Accepted answers

You can use the below step.

Create a module with no dimensiona and below line items
Create a date formatted line item “current date”, populate it manually for the first time.
Create another line item with “Next date” and apply the formula: current date + 1
Create a saved view with “Next date” line item only and then an import action that maps 'next date' to 'current date' line item.
Schedule this import to run once everyday using CloudWorks.

Hope this resolves your issue

You can use the below step.

Create a module with no dimensiona and below line items
Create a date formatted line item “current date”, populate it manually for the first time.
Create another line item with “Next date” and apply the formula: current date + 1
Create a saved view with “Next date” line item only and then an import action that maps 'next date' to 'current date' line item.
Schedule this import to run once everyday using CloudWorks.

Hope this resolves your issue

Dimensionality - Formula Help
I have a Price module where customers are ranked based on their unit prices. I also have a Comparison module, where I want to display the names and unit prices of top-ranked customers for comparison. The model includes a Customers list. In the Comparison module, I want to write formulas to bring in the customer names and…
Can there be a duplication in Process ID's
Can there be a duplication in Process ID's
Using Polaris and Classic
Client has spoke models built in Classic and now considering building Data Hub in Polaris in order to deal with sparsity. On the surface this seem possible but likely a bad idea. Has anyone done anything similar to this? Specifically, what did you have to do to ensure that data was compatible? Any thoughts or suggestions…