Convert Text Field to Date Field?

[ramcena306]

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 ?

[Anil_Babu_Samineni]

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

[Anonymous]

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

or

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

[its_anandrjs · Accepted solution]

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')