data binding date format issue

chris_la · Post by **chris_la** » Wed Jun 29, 2016 11:53 am

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.

odklizec · Post by **odklizec** » Wed Jun 29, 2016 12:00 pm

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.

chris_la · Post by **chris_la** » Wed Jun 29, 2016 4:12 pm

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

Ranorex Forum

data binding date format issue

data binding date format issue

Re: data binding date format issue

Re: data binding date format issue