text to date

[dkma]

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!

[atcodedog05 · Accepted solution]

Hi @dkma 

Use todate() formula like below.

Hope this helps : )

[Luke_C]

@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')

[dkma]

Thanks for the help, i changed the text to number then todate(....) it worked.. thanks for the trick

[atcodedog05]

Happy to help : ) @dkma 

Cheers and have a nice day!