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 …

Setting an empty date in automations

Chr1sG March 3, 2026, 9:49am 5

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

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