![]() ![]() On msuOrange formula, it works by comparing the current date to the one in the formula and basically returning the time between current date and the reference date+1 on the span you selected. Something like the weekly one I posted.msuOrange's formula, which is more compact.I'll do a general explanation and then say what I think it happening prior to eyeing your formulaįrom this thread and further experimentation, there are 2 common ways to accomplish a recurring tasks: I can't open your link, I don't have permissions it seems, but I think I might know what's up. I'm pretty sure there will be a LOT of people that will find them VERY VERY useful (based on my humble lurking of the sub). Please tell me if they work properly for your guys! I copied and pasted them from a secondary database and pasted them back and they still work, so i think i didn't mess them up, but might be wrong. You can adjust the or order changing the parameters like "MMM DD -" to whatever you want. The date might seem weird to you guys, I just like to present them is a descending way. This will basically return something like "2020's Week 14 (Mar 30 - Apr 05)". I adapted it a bit, because my dates have diferent years and i want to see the year. Get the Week of the Year: This one's on ben. Or, you can just have a Formula Property be day(prop("Dates")) and filter out 6 and 0. Will return True if it's not the Weekend, else, it's False. If you want to be able to display working days (or just the tasks of a particular weekday, let's say, for a Calendar or list view with Monday tasks or something), you can use the day() function to add a conditional (either as just Filter or in a Formula Property to Filter By). (formatDate(prop("Dates"), "YW") = formatDate(now(), "YW")) ? "Due this Week!" : ""Īs a little bonus. ![]() This will let you only display dates this week! The main benefit is that this is a dynamic formula, so it will always display this week. You then Filter By this value being Not Empty. If(now() now(), prop("Dates"), if(formatDate(now(), "ddd") = formatDate(prop("Dates"), "ddd"), dateAdd(prop("Dates"), abs(dateBetween(now(), prop("Dates"), "days")), "days"), dateAdd(prop("Dates"), abs(dateBetween(prop("Dates"), now(), "days")) + 7 - abs(mod(dateBetween(prop("Dates"), now(), "days"), 7)), "days")))įilter by this Week: This I came up with myself, but i know ben has an example of this too! This will return a value if the date is due this week (Due this Week!), else, it will be empty. Perfect for birthdays, anniversaries and the sort! I added a check to display future days as the date itself: Yearly recurring tasks : This formula will update a date to be it's equivalent for the next year. I made these myself from scratch (unless specified otherwise), but i haven't checked all of and u/ben-something 's examples, so it might be there. I would like to share some formulas I've been sort of working on, they might prove useful. EDIT: There is a version 2 for the recurring tasks, more sexy and compact based on the comments posted here. ![]()
0 Comments
Leave a Reply. |