topic Re: Date Format + NUM in QlikView

Date Format + NUM

Anonymous — Sat, 13 Feb 2016 08:02:48 GMT

Hi folks,

I Have a date Field in the following format YYYY-MM-DD hh:mm:ss now i want to to convert into Number in script

i.e Num(Date#(TransactionDate,'YYYY-MM-DD hh:mm:ss')) as TransactionDt

but the problem here is im getting output as 42400.2564123.. where i dont want decimal value.

expected output : 42400.

MarcoWedel — Sat, 13 Feb 2016 08:16:35 GMT

‌use floor() instead of num.

regards

Marco

HirisH_V7 — Sat, 13 Feb 2016 08:36:42 GMT

Hi,

Try this,

ceil(Num(Date#(TransactionDate,'YYYY-MM-DD hh:mm:ss'))) as tdate,
Date#(Floor(TransactionDate),'YYYY-MM-DD hh:mm:ss') as tdate2

HTH,

Hirish

maxgro — Sat, 13 Feb 2016 10:56:04 GMT

you ca use floor and frac to get the date and time part