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: 
ramcena306
Creator
Creator

Convert Text Field to Date Field?

A field 'Order_date' is in MM/DD/YYYY format. However this field is not being interpreted as a date field, and behaves as a normal text filed; due to which none of the date functions are working on this field.

How can i write an expression to convert the field to a date field ?

1 Solution

Accepted Solutions
its_anandrjs

Try One of this

Date(Date#(Order_date, 'MM/DD/YYYY'), 'MM/DD/YYYY')


Or


Date(Floor(Order_date), 'MM/DD/YYYY')


Or


Date(Order_date, 'MM/DD/YYYY')

View solution in original post

3 Replies
Anil_Babu_Samineni

Normal Date() and Date#() combination should return, Will you provide some data set rows?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
psilva001
Creator
Creator

DATE(Order_date, 'MM/DD/YYYY')

or

DATE(DATE#(Order_date, 'MM/DD/YYYY'), 'MM/DD/YYYY')

its_anandrjs

Try One of this

Date(Date#(Order_date, 'MM/DD/YYYY'), 'MM/DD/YYYY')


Or


Date(Floor(Order_date), 'MM/DD/YYYY')


Or


Date(Order_date, 'MM/DD/YYYY')