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!

Answers

  • 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