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 expected. The issue is related to AdjustMonth().
The docs:
https://login.quickbase.com/db/6ewwzuuj?a=dr&r=be&rl=3
"Returns the date which is m months after the given date d, with the same day number. If the day doesn't exist in that month, the last day of that month is returned."
Thus I'd expect...
AdjustMonth( Date( 2019,06,01 ) , 1 ) to return 2019/07/01 -- one month forward. Works as expected.
AdjustMonth( Date( 2019,06,30 ) , 1 ) to return 2019/07/30 -- one month forward. Works as expected.
AdjustMonth( Date( 2019,06,31 ) , 1 ) to return 2019/07/31 -- one month forward. But no. It decided July should only have 30 days. I always get back 2019/07/30 which is not what the docs lead me to believe is correct.
This is a "same day of the next / previous month... months...etc." not an "add/subtract 30 days" function, correct?
Thoughts? Advice?
This is really messing with my ability to generate valid reports for clients that have a billing date on the 31st of a month.
Today I learned that some of my calculated date fields are NOT yielding the results I expected. The issue is related to AdjustMonth().
The docs:
https://login.quickbase.com/db/6ewwzuuj?a=dr&r=be&rl=3
"Returns the date which is m months after the given date d, with the same day number. If the day doesn't exist in that month, the last day of that month is returned."
Thus I'd expect...
AdjustMonth( Date( 2019,06,01 ) , 1 ) to return 2019/07/01 -- one month forward. Works as expected.
AdjustMonth( Date( 2019,06,30 ) , 1 ) to return 2019/07/30 -- one month forward. Works as expected.
AdjustMonth( Date( 2019,06,31 ) , 1 ) to return 2019/07/31 -- one month forward. But no. It decided July should only have 30 days. I always get back 2019/07/30 which is not what the docs lead me to believe is correct.
This is a "same day of the next / previous month... months...etc." not an "add/subtract 30 days" function, correct?
Thoughts? Advice?
This is really messing with my ability to generate valid reports for clients that have a billing date on the 31st of a month.
