DATETIME_PARSE AND CONCATENATE

[SANTIAGO_GARCIA]

Hi there! I’ve been using DATETIME_PARSE for some time now to convert outputs (datetime strings) from formulas into dates with format but now DATETIME_PARSE is not working anymore. I don´t know if Airtable has made any updates around this function recently?

Just to give a further context, I use DATETIME_PARSE to convert datetime strings (with this format ‘DD/MM/YYYY’) resulting from a formula into Dates with a format that Airtable can read in order to compare them with other dates (these dates have the Airtable format). DATETIME_PARSE used to convert them into comparable dates but now the formula says #ERROR! all the time.

If any of you know about any updates Airtable made around this formula or instead knows how I could solve this problema please let me know!! I’ve already tried 1.000 different things :frowning:

Thank you for your time!!!

[HeyJessiJay]

Same problem.

I'm pulling a date in a lookup field and need it to be recognizable as a date for automation. 

Name	End Date		End Date Lookup	Formatted Date
Description	Lookup Source		Lookup Date	Parse Function
Settings	Time is Off		Time is Off	Time is Off
			Tried same TZ on & off	Tried same TZ on & off
	Timezone is Hidden		Timezone is Hidden	Timezone is Hidden
	Local Date Format		Local Date Format	Local Date Format
Formula				DATETIME_PARSE({End Date Lookup},'MM/DD/YYYY')
Output/Text	6/14/2023		6/14/2023	#ERROR!