Hello,
In my data in excel i have dates in 2 formats - due to which Alteryx is getting confused for dates - so what's the best way to make this in one single Alteryx readable format?
Alteryx is calculating wrong days for this format - "02/01/2022 17:00"
| Date |
| 02/01/2022 17:00 |
| 02/02/2022 17:00 |
| 02/03/2022 17:00 |
| 02/04/2022 17:00 |
| 02/07/2022 17:00 |
| 02/08/2022 17:00 |
| 02/09/2022 17:00 |
| 02/10/2022 17:00 |
| 02/11/2022 17:00 |
| 2/14/2022 5:00:00 PM |
| 2/15/2022 5:00:00 PM |
| 2/16/2022 5:00:00 PM |
| 2/17/2022 5:00:00 PM |
| 2/18/2022 5:00:00 PM |
| 2/21/2022 5:00:00 PM |
| 2/22/2022 5:00:00 PM |
| 2/23/2022 5:00:00 PM |
| 2/24/2022 5:00:00 PM |
| 2/25/2022 5:00:00 PM |
| 2/28/2022 5:00:00 PM |
| 03/01/2022 17:00 |
| 03/02/2022 17:00 |
| 03/03/2022 17:00 |
| 03/04/2022 17:00 |
| 03/07/2022 17:00 |
| 03/08/2022 17:00 |
