CSV connector date field parsing expects US format (mm/dd/yyyy)

Adrian Corston 1 year ago in CSV connector updated by Beau Harrison (Senior Software Engineer) 1 year ago 3

I have a CSV connector with a date field, and it is expecting US date format (mm/dd/yyyy).  Can this be set to expect Australia format (dd/mm/yyyy) instead, or should I parse it by hand using a PowerShell transform in my adapter?

Satisfaction mark by Adrian Corston 1 year ago
Under review

Hi Adrian

The expected format is determined by the Windows users default locale setting. Normally easy enough to change, but I'm not sure how that works on hosted service like Connect. Reach out to David if that's something you want to explore. Doing this will affect all of Broker, though, and while the change should be handled gracefully, there is the risk of issue arising from the change.

Alternatively, use set the connector date field as a string and use PowerShell to convert to and from DateTime using the desired format/culture.

Thanks Beau, that's what I thought.  You can close this ticket.