Hi Community,
This is a bit of an odd one I was sent over a file yesterday evening from a colleague and one of the fields called EntryDate contained "Dates" in a string format however they are in a very weird looking format as seen below for example 1/13/2023 there cant be 13 months in a year.
Would anyone be able to help me convert these weird dates to the standard Altyerx format?
Any and all help is much appreciated as always.
Here a sample of the dates:
| EntryDate |
| 01/12/2023 |
| 1/13/2023 0:00 |
| 01/11/2023 |
| 01/12/2023 |
| 1/13/2023 0:00 |
| 1/16/2023 0:00 |
| 01/09/2023 |
| 01/10/2023 |
| 01/11/2023 |
| 01/12/2023 |
| 1/13/2023 0:00 |
| 01/12/2023 |
| 01/10/2023 |
| 01/11/2023 |
| 01/12/2023 |
| 1/13/2023 0:00 |
| 01/10/2023 |
| 01/12/2023 |
| 01/12/2023 |
| 01/11/2023 |
| 1/13/2023 0:00 |
