Ranorex Forum

Hi,

I'm new to Ranorex, my company recently brought licenses and we're looking to start our automation journey.

I am trying to data bind some fields, 1 of which is a date field.

I'm binding to an excel spread sheet and the date field I have tried in the format of YYYY-MM-DD and DD/MM/YYYY but when previewing the data in ranorex, its viewing it in the US format MM/DD/YYYY.

This is causing me errors for dates e.g. today 29/06/2016 is coming through as 06/29/2016 which is not a valid date.

Is there anyway I can stop this?
I am based in the UK and all my machine location settings are set to UK.

Any help would be greatly appreciated.

Hi Chris and welcome here,

I think the easiest way to fix your problem would be to convert the affected excel cells to simple 'text' format? Then Ranorex should read the excel cell in exactly the same format, as saved in excel.

Hi Pavel,

Thank you kindly for your reply. I have tested your solution suggestion and this has resolved my issue.

This will be a point that I must be sure to point out to our data team to ensure they do this adjustment to any excel file that they try to feed into our test modules in future.

Thank you again for helping resolve my issue.

Kind Regards
Chris