topic Re: Convert Text Field to Date Field? in QlikView

Convert Text Field to Date Field?

ramcena306 — Wed, 25 Nov 2020 16:16:04 GMT

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 ?

Re: Convert Text Field to Date Field?

Anil_Babu_Samineni — Wed, 25 Oct 2017 16:14:21 GMT

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

Re: Convert Text Field to Date Field?

Anonymous — Wed, 25 Oct 2017 16:15:03 GMT

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

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

Re: Convert Text Field to Date Field?

its_anandrjs — Wed, 25 Oct 2017 16:18:29 GMT

Try One of this

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

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

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