I am trying to map this formula field into a date field in an automation. However, the automation cannot display the date, and I cannot add DATETIME_PARSE to this IF formula. How do I automate adding time to a date field?
P.S. I cannot just use a lookup field, because I have tasks being created from other tables and they all use the same Due Date field, which is tied to further automation down stream.