AdjustMonth Bug or Not?
I'm still learning the ins-and-outs of QuickBase but do have extensive programming and database experience. Today I learned that some of my calculated date fields are NOT yielding the results I exp...
Forum Discussion
I'm likely not a bug - but rather 6/31/2019 isn't an actual date - so it kicks it back to the actual day of the month - 6/30 and adjusts one month in the future accordingly.
You can do a LastDayOfTheMonth() formula to catch exceptions like that though. So LastDayOfMonth(AdjustMonth(Todate("6/30/2019")))
Chayce Duncan | Director of Strategic Solutions
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base
You can do a LastDayOfTheMonth() formula to catch exceptions like that though. So LastDayOfMonth(AdjustMonth(Todate("6/30/2019")))
Chayce Duncan | Director of Strategic Solutions
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base
I was just updating my post to suggest using the LastDayOfMonth() formula with the AdjustMonth function as well... Chayce beat me to it!
