Ben SmithBen Smith
Ben Smith/
Yesterday/Today/Next
Yesterday/Today/Next
Yesterday/Today/Next

Yesterday/Today/Next

For
red458italia
From
Reddit
Status
Updating
Formulas
+
+
&& · and
&& · and
==
==
formatDate
formatDate
now
now
|| · or
|| · or
-
-
Share
Tasks

Today/Yesterday

formatDate(prop("Due Date"), "L") == formatDate(now(), "L") or format(toNumber(formatDate(now(), "DDD")) - 1) + formatDate(prop("Due Date"), "Y") == formatDate(prop("Due Date"), "DDDY")

Now/Next

prop("Status") == "Now" or prop("Status") == "Next"

Yesterday/Today and Now/Next

(formatDate(prop("Due Date"), "L") == formatDate(now(), "L") or format(toNumber(formatDate(now(), "DDD")) - 1) + formatDate(prop("Due Date"), "Y") == formatDate(prop("Due Date"), "DDDY")) and (prop("Status") == "Now" or prop("Status") == "Next")

Yesterday/Today/Now/Next

formatDate(prop("Due Date"), "L") == formatDate(now(), "L") or format(toNumber(formatDate(now(), "DDD")) - 1) + formatDate(prop("Due Date"), "Y") == formatDate(prop("Due Date"), "DDDY") or (prop("Status") == "Now" or prop("Status") == "Next")
 
By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!
By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!