Qlikview date formats

[pk]

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 · Accepted solution]

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.