Forum Discussion

Damon_Wang's avatar
Damon_Wang
Occasional Contributor
12 years ago

Start time and stop time in Description.tcLog

I got start time in Description.tcLog like this 41645.0917384028, could anyone tell me what date it is? It seems it's based on a time 1899/12/30? Why it's not 1899/12/31?

1 Reply

  • TanyaYatskovska's avatar
    TanyaYatskovska
    Icon for Alumni rankAlumni
    12 years ago

    Hi Damon,


     


    Convert the digit format to Date - it will be 1/6/2014 2:12:06 AM. Here is the code I used for the conversion:




       //JScript


       var oaDate = VarToFloat(41645.0917384028);


       Log.Message(aqConvert.DateTimeToStr(oaDate));