Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Johan,
Did you try?
Date(Floor(OrderDate)) AS OrderDate
Hope that helps.
BI Consultant
HI,
Try this way.
Load
Date(OrderDate) as OrderDate
From XYZ
Regards,
Kaushik Solanki
I've tried it also but the result is the same.
You may try
Load Distinct SubField(OrderDate,' ',1) as OrderDate1, ...
From ...
Hi,
From where are you getting this data...?
Try this too.
Date(Date#(OrderDate,'YYYY-MM-DD hh:mm:ss'),'DD/MM/YYYY') as OrderDate
Regards,
Kaushik Solanki
Hello Johan,
Did you try?
Date(Floor(OrderDate)) AS OrderDate
Hope that helps.
BI Consultant
Thanks Miguel
Now it works fine.