data binding date format issue

Ranorex Spy, Recorder, and Studio.
chris_la
Posts: 2
Joined: Wed Jun 29, 2016 11:13 am

data binding date format issue

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.

User avatar
odklizec
Ranorex Guru
Ranorex Guru
Posts: 3930
Joined: Mon Aug 13, 2012 9:54 am
Location: Zilina, Slovakia

Re: data binding date format issue

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.
Pavel Kudrys
Ranorex explorer at Descartes Systems

Please add these details to your questions:
  • Ranorex Snapshot. Learn how to create one >here<
  • Ranorex xPath of problematic element(s)
  • Ranorex version
  • OS version
  • HW configuration

chris_la
Posts: 2
Joined: Wed Jun 29, 2016 11:13 am

Re: data binding date format issue

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