Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Sai33
Partner - Creator
Partner - Creator

Convert TextDate to Date

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

Labels (1)
1 Solution

Accepted Solutions
Chanty4u
MVP
MVP

datefor.PNGtry below

Format:

LOAD * INLINE [

    dateformat

    01-FEB-18

];

 

Result:

LOAD *,

 

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

Resident Format;

View solution in original post

2 Replies
Chanty4u
MVP
MVP

datefor.PNGtry below

Format:

LOAD * INLINE [

    dateformat

    01-FEB-18

];

 

Result:

LOAD *,

 

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

Resident Format;

Chanty4u
MVP
MVP

You can go through below document for mixed date formats.

https://community.qlik.com/t5/Qlik-Sense-Documents/Multiple-Dates-Using-Alt/ta-p/1493744