topic Re: Convert date time to num in QlikView

Convert date time to num

anuradhaa — Tue, 10 Nov 2015 07:37:12 GMT

Hi,

I have below expression and i want to convert it num()

Please help

date(ReloadTime() ,'YYYY-MM-DD') &' '& time(MakeTime(6,30),'hh:mm')

Thank You

Re: Convert date time to num

Chanty4u — Tue, 10 Nov 2015 07:47:45 GMT

use Alt() fun,

try lik dis

hope this helps you

Alt(Date#(DateField, 'd/M/yyyy'), Date#(DateField, 'M/d/yyyy'),Date#(DateField, 'd/MMM/yyyy'), ...............

)

thanks

Suresh

Re: Convert date time to num

Anonymous — Tue, 10 Nov 2015 07:53:10 GMT

try this:

=num(timestamp#(date(ReloadTime(),'DD/MMM/YYYY')&' '&Time(MakeTime(6,30),'hh:mm'),'DD/MMM/YYYY hh:mm'))

Re: Convert date time to num

maxgro — Tue, 10 Nov 2015 07:55:28 GMT

floor(ReloadTime()) + MakeTime(6,30)

Re: Convert date time to num

anuradhaa — Tue, 10 Nov 2015 08:53:47 GMT

if i used floor(ReloadTime()) it use both date n time. but i want only the date

Re: Convert date time to num

tresB — Tue, 10 Nov 2015 08:59:59 GMT

The reverse is true. If you use floor(), it gives you the integer part of a timestamp and that doesn't contain time but the date only. The fraction part of a timestamp is responsible for time.