Importing custom timestamps

New Contributor

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!

Frequent Contributor

Re: Importing custom timestamps



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