Creation date for the record entered

pnataraj

Hello

Need your help in finding way to populate the creation Date/time for the new record entered in the General List.

Thanks

Regards

Prabakaran

Accepted answers

All comments

PaulRitner

Hi,

Unfortunately, Anaplan doesn't have a date/time concept (like Excel's NOW).

I've seen the following methods used to document a date/time stamp

One client manually exports the transaction history daily and an automated process picks up the file, cleanses it, and reloades timestamp information for selected types of transactions. This approach is not ideal, but does work well in certain circumstances... but breaks down with most, but not all, bulk changes (because bulk data changes often don't make the exact changes viewable when querying history).
Another client loads a date/time stamp to a single cell each time a particular process runs. They also document date/time for bulk loads (at the list item level). However, both of these are controlled by automated processes... getting this right manually is probably a non-starter.

I'd love to see what other folks have done... the community comes up with some interesting ways to get things done!

Paul

Hayk

Hi Paul,

Nice idea with history, but I assume that account set for automatic history extraction should have admin access?

We use second approach, but with date stamp only.
And it works well.

PaulRitner

Hi Hayk,

Yes, the user ID would need to be an Admin. Also, the history extraction can only be done manually (the processes after the extraction can be automated, but the extraction itself is a manual task at this point).

Paul

Quick Links

Can you help?

Unanswered questions

Data Integration to Fluence workspace
Hello Everyone, I am seeking guidance on how I could create a workflow process in Fluence consolidation workspace, using the ADO import task. Does anybody know what kind of information I need to fill in these fields? I have watched the ADO training but only explains the data transformation and integration within Anaplan…
Anaplan add-in for Power Point security issue
Hello everyone I am going through an issue with security when logging into Anaplan via power point add-in. I am a workspace administrator and SSO user. But once I installed add-in for power point, I am not able to login. I am using Universal Login (default) connection and it asks for user name and then a password (not…
Pagination in Management Reports Without splitting Parent Blocks
Hi I would like to set up pagination in management reports by assigning a page number to a list item and its parent but I also want to be able to keep a block of parent and list items together and not split over two pages. E.g. Parent 1 - 1 Child 1 - 2 Child 2 - 3 Parent 2 - 4 Child 3 - 5 Child 4 - 6 Child 5 - 7…