Importing custom timestamps

[max_soloviev]

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!

[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