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!
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