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

3 Replies

Related Content

Relationships functional question

Nz Function - Formula Help

Specific permissions needed to run a copy master and detail button?

Do unused tables related to currently used tables cause functionality problems?

Assistance Needed to Locate Formula Fields which include Specific String

Recent Discussions

When the Expiration Date is On or Before Today, Change the Contract Status to Expired

Forms help

'Is Set' in Pipelines

Share your feedback on the new Qrew Discussions

Empower Next Week!