Setting an empty date in automations

Bugs & Issues
1

I want to use either return a calculated due date or return an empty date if the fields to calculate the due date is missing. Adding an empty string is easy: “”. adding an empty relation is also not too hard: filter for true=false. (thanks for the trick Chris!).

But how to add an empty date? I got a solution! But it might be a bug…

Add a new formula field and give it: Date(0, 0, 0). This will then be an empty date you can reference in the automation.

BUT! If you try to do this in the automation directly, it’ll throw an error: ERROR: date field value out of range: 0-00-00…

So I’m not sure if the bug is the fact that this is possible in the formula field, or the fact that its not possible in the automation…

2

Not an answer to the question of what’s a bug and what’s not, but you can get an empty date in an automation formula using this workaround Users.Filter(true=false).Sort().First().[Creation Date]
or something similar.

3

You come up with the most crazy work arounds. I’ll change to this as it feels less finicky than what I suggested above.

Thanks!!