text to date

Hi all,

the attached file consists two columns

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!

Accepted answers

Use todate() formula like below.

Hope this helps : )

Use todate() formula like below.

Hope this helps : )

@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!