Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Date Error

In my file, I have the date specified in MM-DD-YYYY Format, when I transform the dates to date format few rows displays as Error. I'm not sure how to change the MM-DD-YYYY format to DD-MM-YYYY. Any help would be appreciated. Thanks 

 

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    right-click on the column headder > click change type > Click using Locale > Select date then US

     

    I would ❤ Kudos if my solution helped.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    right-click on the column headder > click change type > Click using Locale > Select date then US

     

    I would ❤ Kudos if my solution helped.