Timestamp Issue

[#1]

Hi All,

I am loading data from an xlsx file. There is a column present in the file which has values in datetime format such as 1/3/2015 17:45.

While loading it in qlikview, I am getting it in number format.

How do I get the timestamp format in which the data is present in the excel into the specific column in the script?

Thanks,

Asma

[ToniKautto]

Use the Timestamp() function to format the number into a timestamp. By the below principle.

LOAD

     Timestamp(MyTimestampField) AS MyTimestamp

FROM myfile.xlsx

If you need more detailed help a sample XLSX file and QVW file would make it a lot easier to understand what happens in your scenario.

[PrashantSangle]

Hi,

Try any of the below two

Timestamp(fieldName,'DD/MM/YYYY hh:mm')

or

Date(fieldName,'DD/MM/YYYY hh:mm')

Regards

[#4]

It is worth mentioning that all datetimes in qlikview  is represented by floating point number.  the whole number is the days passed since 31 December 1899 and the fractional value is the time.

using the previously mentioned function will put them in the format we know.