Date conditions

Updated November 9, 2026

When a condition looks at a Date field, it compares calendar days. It works with every kind of Date field: date picker, three boxes or drop-downs, in any date format.

Operators

OperatorTrue when the date…
isis that day.
is notis not that day, or is empty.
is afteris later than that day. The same day doesn’t count.
is beforeis earlier than that day. The same day doesn’t count.
is emptyis not filled in, or is only partly filled in.
is not emptyis a complete date.

The value to compare with

TypeExampleMeans
M/D/YYYY6/14/2027June 14, 2027
YYYY-MM-DD2027-06-14June 14, 2027
{today}{today}, {today+30}, {today-1 week}A day worked out from today. See Dates and {today}.
Another Date field@{Start date:3}Whatever that field holds, read in its own format.

Under the box, KodaFill shows the date as the watched field shows it, for example Compared as 06/14/2027, so you can check it. If the value can’t be read you see Not a date KodaFill can read, and the condition is never true (and is not is always true).

Typed dates are always month first (M/D/YYYY) or year first (YYYY-MM-DD), even when the field shows dates day first. 3/4/2027 always means March 4.

On or after, on or before

is after and is before leave out the day itself. To include it, use two conditions with Match any of these conditions: Event date is after 6/14/2027 or Event date is 6/14/2027. Or move the day by one: is after 6/13/2027.

Examples

ConditionTrue when
Event date is before {today}The event date is in the past.
Event date is after {today+30}The event is more than 30 days away.
End date is before @{Start date:3}Someone picked an end date earlier than the start date.
Was this page helpful?
Scroll to top