topic Re: conversion of decimal values to date format in QlikView

conversion of decimal values to date format

Anonymous — Tue, 05 Dec 2017 11:24:42 GMT

how to convert conversion of decimal values to date format

Re: conversion of decimal values to date format

prieper — Tue, 05 Dec 2017 11:27:21 GMT

TIMESTAMP(MyField) should do

Re: conversion of decimal values to date format

Colin-Albert — Tue, 05 Dec 2017 11:35:02 GMT

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!

Re: conversion of decimal values to date format

Anonymous — Tue, 05 Dec 2017 13:04:36 GMT

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 ,

Re: conversion of decimal values to date format

Anonymous — Tue, 05 Dec 2017 13:16:47 GMT

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

Re: conversion of decimal values to date format

Anonymous — Tue, 05 Dec 2017 13:23:45 GMT

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

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

Re: conversion of decimal values to date format

Colin-Albert — Tue, 05 Dec 2017 13:26:35 GMT

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]';