Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

datetime field is displaying decimal data while loading qvd

Hi,

I have date fieldname having datetime datatype but when I load qvd data is dilsplaing with decimals not in date format.

how i load this data.Administrator

1 Solution

Accepted Solutions
Not applicable
Author

Hi

Have you loaded the data as below;

timestamp( A,'YYYY-MM-DD hh.mm')


Where A is your data field.



Regards


Steve

View solution in original post

2 Replies
Not applicable
Author

Hi

Have you loaded the data as below;

timestamp( A,'YYYY-MM-DD hh.mm')


Where A is your data field.



Regards


Steve

israrkhan
Specialist II
Specialist II

Hi Pankaj.

use Date#() and Date() function in in load script to format the date accordingly.

read in help file about these functions.