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



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