I had a formula that was working until this week and has now broken for some reason. I looked into the basics (did the field names for the formula change, synced fields change, anything like that) but literally nothing about the components of the formula broke, so I’m unsure why it’s now resulting in #ERROR rather than the result. Formula below, it’s honestly incredibly basic. Any ideas for simple things I could be missing?
DATETIME_PARSE(ARRAYJOIN({Release Date_static}), ‘MM-DD-YYYY’)
Where {Release Date_static} is a lookup of a single line text field with a date in ‘YYYY-MM-DD’ format.