Hello,
In my extended SLCos IDO, I would like to create a derived field which would convert the OrderDate property to a DATETIME format. I have tried all morning without success. Would someone be able to help me please?
Hi Kyle, can you please send us an example of the query you are using in your derived field?
I created a derived field called ue_JMW_DerOrderDateTime with a DateTime property class and put the following expression in the implementation:
SELECT CONVERT(datetime, OrderDate)
Immediately, the OrderDate (which is a property in the SLCos ido ) becomes underlined and the derived field produces no data in any dataview in which it is selected.
Got it to work: I should have used:
CONVERT(datetime, OrderDate, 121)