+if(now() > prop("End Date"), prop("End Date"), if(prop("Status") == "Done!", prop("Date"), if(not empty("Repeat") and prop("Date") > now(), prop("Date"), if(prop("Repeat") == "Daily", dateAdd(prop("Date"), floor(floor((timestamp(now()) - timestamp(prop("Date"))) / 86400000) / 1) * 1 + 1, "days"), if(prop("Repeat") == "Weekly", dateAdd(prop("Date"), floor(floor((timestamp(now()) - timestamp(prop("Date"))) / 86400000) / 7) * 7 + 7, "days"), if(prop("Repeat") == "Biweekly", dateAdd(prop("Date"), floor(floor((timestamp(now()) - timestamp(prop("Date"))) / 86400000) / 14) * 14 + 14, "days"), if(prop("Repeat") == "Monthly", if(dateAdd(dateAdd(prop("Date"), year(now()) - year(prop("Date")), "years"), month(now()) - month(prop("Date")), "months") < now(), dateAdd(dateAdd(prop("Date"), year(now()) - year(prop("Date")), "years"), month(now()) - month(prop("Date")) + 1, "months"), dateAdd(dateAdd(prop("Date"), year(now()) - year(prop("Date")), "years"), month(now()) - month(prop("Date")), "months")), if(prop("Repeat") == "Quarterly", if(dateAdd(dateAdd(dateAdd(prop("Date"), round((month(now()) - month(prop("Date"))) / 3) * 3, "months"), year(now()) - year(prop("Date")), "years"), 24, "hours") < now(), dateAdd(dateAdd(prop("Date"), round((month(now()) - month(prop("Date"))) / 3) * 3 + 3, "months"), year(now()) - year(prop("Date")), "years"), dateAdd(dateAdd(prop("Date"), round((month(now()) - month(prop("Date"))) / 3) * 3, "months"), year(now()) - year(prop("Date")), "years")), if(contains(prop("Repeat"), "Semi-annually"), if(dateAdd(dateAdd(dateAdd(prop("Date"), round((month(now()) - month(prop("Date"))) / 6) * 6, "months"), year(now()) - year(prop("Date")), "years"), 24, "hours") < now(), dateAdd(dateAdd(prop("Date"), round((month(now()) - month(prop("Date"))) / 6) * 6 + 6, "months"), year(now()) - year(prop("Date")), "years"), dateAdd(dateAdd(prop("Date"), round((month(now()) - month(prop("Date"))) / 6) * 6, "months"), year(now()) - year(prop("Date")), "years")), if(contains(prop("Repeat"), "Annually"), if(dateAdd(dateAdd(prop("Date"), year(now()) - year(prop("Date")), "years"), 24, "hours") < now(), dateAdd(prop("Date"), year(now()) - year(prop("Date")) + 1, "years"), dateAdd(prop("Date"), year(now()) - year(prop("Date")), "years")), prop("Date")))))))))))
0 commit comments