Recur Every D/W/M/Q/Y

Next from First

dateAdd(prop("First"), 1, prop("Every") + "s")

Next from Today

if(formatDate(dateAdd(prop("First"), dateBetween(now(), prop("First"), prop("Every") + "s"), prop("Every") + "s"), "L") == formatDate(now(), "L"), if(empty(prop("Every")) or prop("First") > now(), prop("First"), dateAdd(prop("First"), dateBetween(now(), prop("First"), prop("Every") + "s"), prop("Every") + "s")), if(empty(prop("Every")) or prop("First") > now(), prop("First"), dateAdd(prop("First"), dateBetween(now(), prop("First"), prop("Every") + "s") + 1, prop("Every") + "s")))

Today

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

Every Month

Next

if(formatDate(dateAdd(prop("First"), dateBetween(now(), prop("First"), "months"), "months"), "L") == formatDate(now(), "L"), if(prop("First") > now(), prop("First"), dateAdd(prop("First"), dateBetween(now(), prop("First"), "months"), "months")), if(prop("First") > now(), prop("First"), dateAdd(prop("First"), dateBetween(now(), prop("First"), "months") + 1, "months")))

By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!