Importing custom timestamps

Hi There,

I'm trying to import property that has unrecognized date/time format, e.g. Sun, Mar 5, 2017 9:07 PM

I see that date format allows setting custom format and use "?" to ignore certain positions. Unfortunately I cannot find more details or examples how this can be used to import above data.

Thank you!

Accepted answers

All comments

Jaakko

Hi,

You can form the custom pattern in many ways (using commas, spaces and question marks). I think the most challenging part is to get Anaplan to understand 1 and 2 digit day numbers. With this pattern I managed to get this to work.

?????MMM?D, YYYY????????

I think this will convert

Sun, Mar 5, 2017 9:07 PM --> 3/5/2017

Wed, Apr 12, 2017 11:11 PM -> 4/12/2017

Quick Links

Can you help?

Unanswered questions

Invalid Parent - Combined List
Hello Anaplan Community, I have a product hierarchy with 5 levels . For a client requirement, I need to transform this product hierarchy into a combined list , to be able to select different levels of the hierarchy in a line item (drop down list) For this, I tried to create different saved views where I have for example :…
Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…