Time Conversion

[#1]

the raw data I got for time is something like 41271.378252315, how can I convert it to the date time format like "01/01/2013 05:01:33 am"?

[#2]

Hi,

You should use the date() function, ex.

Date(41271.378252315, 'DD/MM/YYYY hh:mm:ss TT')

or

Date(41271.378252315, '$(TimestampFormat)') TimestampFormat is a QV System variable, it's define the full date time format. (See the script)

Regards,

Ricardo

[#3]

Hi,

Have you tried using the date function? For instance

=date(41271.378252315) returns 12/28/2012

See attached.

Hope that helps.

Matt

[montgomery7aust]

Hi Kelly,

You have a couple of options, but the easiest is to load the field into an object and go to the Number tab and select Timestamp.  You can also do this in the script editor by prefacing the field with Timestamp(<your date field here>), as shown below, and this will then show the field as a date whenever it's used in an object (aka globally).

LOAD Timestamp(Date)

FROM

[\\vmware-host\Shared Folders\Desktop\date.xlsx]

(ooxml, embedded labels, table is Sheet1);

Hope this helps!

-Austin

[kaushiknsolanki]

Hi,

     Try this.

     Timestamp( 41271.378252315)

Regards,

Kaushik Solanki