AdjustMonth function help needed

  • 1
  • 1
  • Question
  • Updated 3 months ago
  • Answered
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.
Photo of Michael Black

Michael Black

  • 100 Points 100 badge 2x thumb

Posted 3 months ago

  • 1
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,168 Points 50k badge 2x thumb
try this

[Date of Investor Merchandise Received] + Days(45)

The Adjustmonth only adjusts by integer months.
Photo of Michael Black

Michael Black

  • 100 Points 100 badge 2x thumb
Sheesh, something so simple. I was searching and searching for the answer. Thanks so much. It worked beautifully.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,168 Points 50k badge 2x thumb
Here is a handy link to bookmark of all the functions with usage examples
https://login.quickbase.com/db/6ewwzuuj?a=q&qid=1000132