AdjustMonth function help needed

Question

I am attempting to adjust the days from a field by 45 days. I tried this:

AdjustMonth([Date of Investor Merchandise Received], 1.5)

For all of you that know your stuff, will know that does not give me the result that I am looking for. Any help you could give would be greatly appreciated.

quickbasecoachd · Answer

try this[Date of Investor Merchandise Received] + Days(45)The Adjustmonth only adjusts by integer months.

michaelblack · Answer

Sheesh, something so simple. I was searching and searching for the answer. Thanks so much. It worked beautifully.

quickbasecoachd · Answer

Here is a handy link to bookmark of all the functions with usage exampleshttps://login.quickbase.com/db/6ewwzuuj?a=q&amp;qid=1000132

Forum Discussion

AdjustMonth function help needed

Related Content

Scheduling Formula needed

Database Expert Needed

Nz Function - Formula Help

Jinja Date functions

Rebuild Database Expert Needed