Dates change format when transferred into StudioX?

[g.downes]

Dates that are in a ddmmyyy format in an excel file change to a mmddyyyy when I use a ‘type into’ activity for App/Browser. I’ve solved this by adding a ’ to the beginning of the date cell in excel which forces it to a text field but not ideal. Why does StudioX change the date format (which causes the app to fail).

[Raghavendraprasad (Raghavendraprasad Bhat)]

Hi,

I surmise that when excel is read as a datatable the format is taken up automatically, hence either the template that you use to store data in has to have a uniform format (text format) or you need to parse the data in real time when using it after retrieving from the datatable.

Hope this helps