Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have date fields like OrderDate in the format 09-10-19 11:49:20.237000000 PM all dates are same format
if dates are in this format how to convert into normal dates like Date has contain DD/MM/YYYY, DD-MM-YYYY
and how create master calendar by using these dates Kindly help by providing logic
please find the attached date formats
Thanks a lot....
Hi Narayana,
You can try the following formulas:
Date(Floor([OrderDate]),'DD/MM/YYYY')
OR
Date(Date#(Left([OrderDate],8),'DD-MM-YY'),'DD/MM/YYYY')
Jordy
Climber
Thanks you Jordy
it is working fine
Great, please close the ticket if it's solved!
Jordy
Climber