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