topic how to convert datetime to number in QlikView

how to convert datetime to number

Tue, 22 Sep 2015 08:41:32 GMT

Hi Everyone,

I have the following datetime format:

12/11/2010 15:30:00

I would like to know how I can convert this date to look as follow:

20101112153000

Thanks

MK_QSL — Tue, 22 Sep 2015 08:42:32 GMT

TimeStamp(TimeStamp#('12/11/2010 15:30:00','DD/MM/YYYY hh:mm:ss'),'YYYYMMDDhhmmss')

If it is DD/MM then change accordingly..

sasiparupudi1 — Tue, 22 Sep 2015 09:01:05 GMT

if your datatime is not a string,you could use

TimeStamp(YourDateTime,'YYYYMMDDhhmmss')

if it is a string value, then you need to convert it using timestamp#

TimeStamp(TimeStamp#('12/11/2010 15:30:00','DD/MM/YYYY hh:mm:ss'),'YYYYMMDDhhmmss')

hth

Sasi