Forum Discussion

Qrew Commander

3 years ago

Add 3 months to date but not land on a weekend

Any thoughts of how to add 3 months to a date, but if it lands on a saturday or sunday, bounce forward to the monday, or bounce back to the friday? My initial thought is to add the 3 months, check...

MarkShnier__You
3 years ago
np,

https://login.quickbase.com/db/6ewwzuuj?a=dr&rid=153&rl=csi

WeekdayN(AdjustMonth([my date],3))

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------

MarkShnier__You

Qrew Legend

3 years ago

np,

https://login.quickbase.com/db/6ewwzuuj?a=dr&rid=153&rl=csi

WeekdayN(AdjustMonth([my date],3))

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------

MikeTamoush
Qrew Commander
3 years ago
Thanks! I searched the function list but just missed that one! It's ToWeekDayN but your link showed it!

------------------------------
Mike Tamoush
------------------------------
MikeTamoush
Qrew Commander
3 years ago
Now, bonus points if you know how to do that in a Pipeline using Jinja :)

For now, I'm making the field and using the field. I think the Jinja might be a bit ambitious!

------------------------------
Mike Tamoush
------------------------------