I'm sure I'm not the first one to ask this question but I don't see any information on the documentation nor the forum with regard to custom date formats for this workflow step. As per the screenshot, the format field is a drop down and I need to parse in a strangely formatted UTC timestamp with. Does campaign have the ability to parse out only the relevant bits I'm after or do I have to tell the ETL guys to follow campaign's formatting?
No, I tried it by extending the xtk:dataTransfer schema.
I added my custom date format there. It was coming in the Drop Down in the Data Loading Activity, but it was not working. Because the definition of that custom date format is not known to the Adobe Campaign and we can't define that as adobe won't let us dip that deep into the application (Out Of The Box Functionality).