Exception rule error (date)


#1

Hi All,

I’m getting a weird Formation Exception error when trying to pull a date from a CSV. It works on the first row, then throws an exception error

15/05/2018 is not a valid value for Datetime?

I’m using Get Row Item from a saved CSV…

Any thoughts? I’ve checked for spaces etc and that seems fine.


#2

Can you pull it as a string then parse it to a datetime variable?