topic Re: Extract a date from text column / date time stamp in Connectivity & Data Prep

Extract a date from text column / date time stamp

Azeem2018 — Tue, 22 Nov 2022 23:34:47 GMT

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?

Re: Extract a date from text column / date time stamp

Aditya_Chitale — Wed, 23 Nov 2022 06:48:00 GMT

have you tried like this ?

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

Regards,
Aditya

Re: Extract a date from text column / date time stamp

BrunPierre — Wed, 23 Nov 2022 10:43:22 GMT

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