Change the Date format

[soniasweety]

Hi All,

I have date format like below 

OrderDate

2023-27-06

I want this above date format should be shown as below format

OrderDate

27/06/2023

[RafaelBarrios · Accepted solution]

Hi @soniasweety 

if Qlik already identify the field as a date, you only have to set the desired format

=date(OrderDate,'DD/MM/YYYY')

While if qlik identify the field as something else you will need to tell to qlik what is it and then change to the desired format

=date(date#(OrderDate,'YYYY-DD-MM'),'DD/MM/YYYY')

you can tell if it is a date field or not by using the field in a filter pane

if values are aligned to right, its a date

while if aligned to left it would be a text field.

hope it helps

help users find answers! Don't forget to mark a solution that worked for you & to smash the like button!

[soniasweety]

Thanks it worked !!