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!
