topic Qlikview date formats in QlikView

Qlikview date formats

pk — Mon, 06 Dec 2021 12:28:44 GMT

Hello Team,

I have date format like- MM/DD/YYYY HH:SS:MM TT (e.g.- 12/06/2021 12:00:00 AM)

At scripting side, Want to pick/convert date into this format like 06-12-2021(DD-MM-YYYY)

Thanks in advance

Or — Mon, 06 Dec 2021 12:31:02 GMT

You can format a date in any way desired using the date() function, e.g.

Date(YourDate,'DD-MM-YYYY')

Note that if your date contains a timestamp, you'll want to floor() it or apply dayname() to it first to get rid of the time stamp.