topic Convert Date Time to Date in QlikView

Convert Date Time to Date

Wed, 19 Jan 2011 12:19:11 GMT

Hi Guys,

I need to convert my date, (a number like 45302.8333) to date data type, but without the hour.

I using the following. Is there any better way to do it?

Thanks,

Aldo.

Date( num#(PaymentDate) - Frac(PaymentDate), 'DD/MM/YYYY')

tresB — Wed, 19 Jan 2011 12:27:32 GMT

Hi,

If your PaymentDate itself has the numeric values, why can't you simply use: Date(PaymentDate,'DD/MM/YYYY')? fraction would not bother you.

hector — Wed, 19 Jan 2011 13:15:22 GMT

Hi, you can use dayname(field), and this will return only the date part


dayname(45302.8333) = 11-01-2024
timestamp(dayname(45302.8333)) = 11-01-2024 0:00:00

So you can see, the decimal part is removed this is something like date(floor(field))

Rgds

Wed, 19 Jan 2011 13:19:27 GMT

Thanks