Mar 11, 2020 08:58 AM
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!!!
Jun 28, 2023 06:32 PM
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! |