Date Conversions

[narayanaqlik]

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.... 

[JordyWegman]

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

[narayanaqlik]

Thanks you Jordy

it is working fine

[JordyWegman]

Great, please close the ticket if it's solved!

Jordy

Climber