Skip to main content
Question

AdjustMonth function help needed

  • January 23, 2019
  • 0 replies
  • 43 views
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.
    This topic has been closed for replies.

    try this

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

    The Adjustmonth only adjusts by integer months.
    • MichaelBlack
    • Author
    • Registered
    • January 23, 2019
    Sheesh, something so simple. I was searching and searching for the answer. Thanks so much. It worked beautifully.
    Here is a handy link to bookmark of all the functions with usage examples
    https://login.quickbase.com/db/6ewwzuuj?a=q&qid=1000132
    Terms & ConditionsAccessibility statement