topic Re: Convert TextDate to Date in QlikView

Convert TextDate to Date

Sai33 — Sat, 16 Nov 2024 17:46:47 GMT

Hi, I've my Date field as text in the following format, i would like to convert it to Date format

01-FEB-18 is the data in my DB

i would like to convert it to 01.02.2018

Regards

Sai

Chanty4u — Wed, 25 Nov 2020 09:36:30 GMT

try below

Format:

LOAD * INLINE [

dateformat

01-FEB-18

];

Result:

LOAD *,

Date(Date#(dateformat,'DD-MMM-YY'),'DD.MM.YYYY') AS Newdate

Resident Format;

Chanty4u — Wed, 25 Nov 2020 10:31:32 GMT

You can go through below document for mixed date formats.