conversion of decimal values to date format

[Anonymous]

how to convert conversion of decimal values to date format

[prieper]

TIMESTAMP(MyField) should do

[Colin-Albert]

date(floor(YourFieldName))  will convert the decimal timestamp value to a date and removes the time component

time(frac(YourFieldName)) will convert the decimal timestamp value to a time removing the date component

timestamp(YourFieldName) will convert the decimal value to a timestamp

It is better to split timestamp data into separate date & time fields in Qlik as this will reduce the number of unique data values, and so reduce the footprint of your application.

If you only need the date then just create a date field  - 1 value per day rather than storing potentially thousands of values to the millisecond!

[Anonymous]

thankyou,

am experiencing something very weird,

there is one qvd when am loading it as it is its showing me date in correct format ,

when am loading it in another qvw application,its showing incorrect format,

is there any settings in qlikview in this case

as both are the same files ,

[Anonymous]

Post the sample data. we would be able to fix this

[Anonymous]

DATE(DATE#(Timestamp([YourField]), 'QVDDateFormat'), 'Current Format')

doesn't matter if 'QVDDateFormat' and 'Current Format' are equals

[Colin-Albert · Accepted solution]

I would check the date format settings in your load script. They may be different in the two applications.

SET DateFormat='DD/MM/YYYY';

SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';