topic Re: Date Formats in QlikView

Date Formats

pooja_sn — Wed, 25 Nov 2020 16:16:04 GMT

I have my data with a date column having dates in below format.

6/7/2016 9:51 or 6/17/2016 11:10 (M/D/YYYY h:m). How can I convert it to DD/MM/YYYY.

Floor() doesn't work for me in this case.

tresB — Fri, 22 Jul 2016 09:27:35 GMT

Try like:

Date(Floor(Date#(DateField, 'M/D/YYYY h:m')),'DD/MM/YYYY')

mightyqlikers — Fri, 22 Jul 2016 09:31:10 GMT

hi,

you can also do like below

date(floor(num(datefield)),'DD/MM/YYYY')

$@M.

pooja_sn — Fri, 22 Jul 2016 09:31:39 GMT

That worked. Thanks