Extract a date from text column / date time stamp

[Azeem2018]

Hi, qlik experts,

New to qlik community hardly three days...

1)  I have three columns of date which are text format.

Format of text/columns: '25-11-2022 00:00' just want to transform it into a date '25-11-2022'.

Already tried date,date#,floor#, timestamp including# after seeing in qlik community but couldn't get date format.

Currently applied  left and trim functions for calculating difference of two columns, works ok but when I extract one of columns in table chart then text formated date is showing.

2) is there any function to convert text format of any column  into date format or vice versa?

[Aditya_Chitale]

have you tried like this ?

Date(floor(date#(date,'DD-MM-YYYY hh:mm')),'DD-MM-YYYY')

Regards,
Aditya

[BrunPierre]

Date(Timestamp#([Date Column],'DD-MM-YYYY hh:mm'),'DD-MM-YYYY')