| || |
Problem with date import from Excel
I am doing an automated test for an application that need to import some date values from Excel. When I import those values from the script directly, it works, but when I import it from Excel, it does not. The date value from Excel looks exactly like from the script (for example "1.1.2007" - Slovak format) but the application does not accept it. Should I convert that value to another type of string? How? Or should I set some special format in those Excel cells? Thank you very much.
Re: Problem with date import from Excel
Please post here the code snippets in which you retrieve data from Excel and in which you enter data directly to your application without using Excel.
BTW, the following article on working with dates in TestComplete may be of use to you: