Date format 20130924183259.301

[#1]

Hi guys,

I have date in my database in this format

20130924183259.301

and when I load it in QV then it becomes

41541.7729050926

Can you please help me with converting

41541.7729050926

to

20130924183259.301

I am using TimeStamp () which returns me '9/24/2013 6:32:59 PM' and omitting the millisecond part.

Thanks,

Saurabh

[swuehl · Accepted solution]

Try

timestamp(FIELD,'YYYYMMDDhhmmss.fff')

[#3]

try this also,

num(Timefield_name)