Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Sai33
Partner
Partner

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