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 …

[image] RonMakesSystems: But how to add an empty date? 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.

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!!

Hey! This doesn’t seem to work with a number field… Project.[Stage Trackings].Filter(Stage = [This Project Stage].Stage).Count() = 0, Project.[Stage Trackings].Filter(Stage = [This Project Stage].Stage).First().Duration, Project.[Stage Trackings].Filter(Stage = [This Project Stage].Stage).Su…

Day(Users.Filter(false).Max([Creation Date])) :joy:

hahaha, this is crazy. works like charm. thanks Chris!

Setting an empty date in automations

Bugs & Issues

Chr1sG March 3, 2026, 9:49am 5

Day(Users.Filter(false).Max([Creation Date]))

1 Like

Allow to return an empty value from a formula

Topic		Replies	Views
Button/Rule formula cannot set only half of an uninitialized Date Range Bugs & Issues automations , formulas	6	654	May 12, 2022
Allow to return an empty value from a formula Ideas & Features formulas	26	1398	March 10, 2026
Formula 'Generate using AI' keeps on using 'null' Bugs & Issues automations , formulas , ai	1	54	August 1, 2025
Choose order of empty values when sorting on Date field Ideas & Features views	12	1925	April 17, 2024
Trigger automation on specific date Automations	4	351	July 18, 2022

Setting an empty date in automations

Related topics