Date format is showing in number in Qlik sesne. How to convert general format to date format?

[DJ21]

Date format is showing in number in Qlik sesne. How to convert general format to date format? Refer attached. screen shot.

 

[Hania]

Hi,

please use date function as,

Date(date_field_name,'DD/MM/YYYY') 

(on date_field_name    please write LP Target Company)

eg:

Date(44935,'DD/MM/YYYY')   gives me -------> 09/01/2023

Hope this will help you!

[BrunPierre]

Date(Num#(DateField),'DateFormat')