Text to Date doesn't seem to be working

0

Hello all,

This might be a very simple question! I'm trying to set up a calculated date field using a concat function and then a text to date in order to format it to date, but I'm keep having an error saying that

String '7/3/2024' was not recognized as a valid DateTime.

It looks like the conversion function is not working.

Do you know if that only works if selecting a field? Meaning, I need to create the concat information prior and then use the field in the conversion?
Thank you