Forum Discussion

ChrisFaye1's avatar
ChrisFaye1
Qrew Cadet
5 years ago

Formula to display upcoming month (and year) referencing the day from a field

Hi,  Long story short I'm trying to create a formula that, when a month-to-month checkbox is checked, the field will reference another date field, keep the day, but adjust the month and year to be ...
Formulas and functions
ChrisFaye1's avatar
ChrisFaye1
Qrew Cadet
5 years ago
Thank You, Mark!

It wasn't perfect with the turnover based on today's date, but instead simply assumes the next month, but realistically that's all I need it to do so I'm all set!

It'd be interesting to see how it might look if it were adding only if the current date had passed, but, again, this definitely works for my needs. 

Thanks Again!
Chris

------------------------------
Chris
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
If there is a more complicated logic that you can explain, we can enhance the formula.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------