Donate

30 Formula Examples

1. Date (without time) Is Tomorrow

formatDate(dateAdd(now(), 1, "days"), "L") == formatDate(prop("Date"), "L")

2. Date Is Today

formatDate(prop("Date"), "L") == formatDate(now(), "L")

3. Date Is Before Or On Today

now() > prop("Date")

4. Date Is Before Today

now() > prop("Date") and formatDate(prop("Date"), "L") != formatDate(now(), "L")

5. Date Is After Or On Today

formatDate(now(), "L") == formatDate(prop("Date"), "L") or now() < prop("Date")

6. Date Is After Today

now() < prop("Date")

7. Date Lands In This Week (M-Su)

formatDate(prop("Date"), "W") == formatDate(now(), "W")

8. Date Lands In This Week (Su-Sa)

formatDate(prop("Date"), "w") == formatDate(now(), "w")