Forum Discussion

googleid_118035's avatar
googleid_118035
Contributor
11 years ago

Issue with date value format

Hi All,



I am passing a date value from an Excel file and then its enter into the web page by TestComplete.

Problem is date value format been changed while entering into the web page.



Ex;

input data;

date_val = "4/07/2014"; / this value in the Excel file.



Insert value into the web page by TestComplete is "Thu Jul 4 00:00:00 UTC+0530 2013".



...................

Thanks

Dev





  • googleid_118035's avatar
    googleid_118035
    Contributor
    11 years ago
    Hi All,



    Issue get sloved when I format Excel cell.

    Set category as text.



    ..............

    Thanks

    Dev 
  • AlexKaras's avatar
    AlexKaras
    Icon for Champion Level 3 rankChampion Level 3
    11 years ago
    Hi Dev,



    Alternatively, you might try the aqConvert.DateTimeToFormatStr() TestComplete's function and set its format specifier so that only date part is returned.