Forum Discussion

John Tucker's avatar
John Tucker
Copper Contributor
May 14, 2018

HOW DO I CONVERT DATES FROM TWO DIFFERENT FORMATS ?

I receive dates in one of two formats: 

YYYY-MM-DD   or    YYYY-DD-MM

 

 

I would like to have a formula to convert either of these scenarios and convert into the date format MM/DD/YYYY

 

One problem is sometimes these dates come in text format  and not in a date format

Formulas and Functions

1 Reply

  • IngeborgHawighorst's avatar
    IngeborgHawighorst
    MVP
    May 14, 2018

    Hello,

     

    what do you mean with "dates come in text format  and not in a date format"? Can you give an example?

     

    How is the data arriving on your computer? Is it a CSV file? 

     

    If the date format of the source file is not the same as the date format used by your computer, use the import wizard to import the file instead of opening it directly in Excel. The import wizard has a step where you can convert data formats from one form to another.

     

    For more details, please tell us more about your scenario.