Hi all,
the attached file consists two columns
Date in Textfomat | Actual Date |
44463 | 24-09-2021 |
44468 | 29-09-2021 |
The first column is the text format of Actual Date column. this is converted in excel, But when it comes to alterx,
How to detect and convert first column to Date format.
Does anybody has any work around on this please.
Thanks!
Solved! Go to Solution.
@atcodedog05 Learned something new with that function! I would have used the below which gets to the same answer but not as clean as todate()
datetimeadd('1900-01-01',[Date in Textfomat]-2,'days')
Thanks for the help, i changed the text to number then todate(....) it worked.. thanks for the trick
Happy to help : ) @dkma
Cheers and have a nice day!