Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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')
Normal Date() and Date#() combination should return, Will you provide some data set rows?
DATE(Order_date, 'MM/DD/YYYY')
or
DATE(DATE#(Order_date, 'MM/DD/YYYY'), 'MM/DD/YYYY')
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')