Hi,
In my excel sheet I am having a two date time fields, for that I have given the 24 hours format. But after binding the excel sheet in test studio the date time format gets changed.
For Example in Excel Sheet the date time value is "01/21/2015 00" and "01/25/2015 23", but after binding with test studio,the value is "01/21/2015 12:00:00 AM" and "01/25/2015 11:00:00 PM"
For this Problem what can I do? Is there any Possibility to change the format?
In my excel sheet I am having a two date time fields, for that I have given the 24 hours format. But after binding the excel sheet in test studio the date time format gets changed.
For Example in Excel Sheet the date time value is "01/21/2015 00" and "01/25/2015 23", but after binding with test studio,the value is "01/21/2015 12:00:00 AM" and "01/25/2015 11:00:00 PM"
For this Problem what can I do? Is there any Possibility to change the format?
4 Answers, 1 is accepted
0
Hello Aruna,
Unfortunately this cannot be changed. This is done by design and the grid for the data binding is using computer's localization settings. That is why the hour is getting converted.
Thank you for your understanding regarding this matter.
Regards,
Ivaylo
Telerik
Unfortunately this cannot be changed. This is done by design and the grid for the data binding is using computer's localization settings. That is why the hour is getting converted.
Thank you for your understanding regarding this matter.
Regards,
Ivaylo
Telerik
0
Hello Aruna,
Please try the following workaround for the problem you are experiencing:
If you precede the text in Excel with a ‘ character, Excel will treat the data as a plain string instead of interpreting it as a date.
Give it a try and I hope it helps.
Regards,
Ivaylo
Telerik
Please try the following workaround for the problem you are experiencing:
If you precede the text in Excel with a ‘ character, Excel will treat the data as a plain string instead of interpreting it as a date.
Give it a try and I hope it helps.
Regards,
Ivaylo
Telerik
0
Satpreet
Top achievements
Rank 1
Rank 1
answered on 27 Jan 2017, 09:33 PM
I am having the same issue, Having a date field in CSV file. On binding it is changing its format from 1988-JUN-1 to 6/1/1988 12.
If we add character ' , that conflicts with the application's validations. I think Test Studio should provide freedom to use data as it is because in some cases I might need to test behavior for incorrect entries also.
Please suggest any other workaround if possible.
0
Hello Satpreet,
Please note that these are limitations of the chosen format for data source. Currently if you use an excel sheet the data will be transferred into Test Studio exactly the way it is written in the file. Please give it a try and let me know if it will work for you.
Regards,
Elena Tsvetkova
Telerik by Progress
Please note that these are limitations of the chosen format for data source. Currently if you use an excel sheet the data will be transferred into Test Studio exactly the way it is written in the file. Please give it a try and let me know if it will work for you.
Regards,
Elena Tsvetkova
Telerik by Progress