Discussions

Expand all | Collapse all

AdjustMonth function help needed

  • 1.  AdjustMonth function help needed

    Posted 01-23-2019 17:19
    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.


  • 2.  RE: AdjustMonth function help needed

    Posted 01-23-2019 17:22
    try this

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

    The Adjustmonth only adjusts by integer months.


  • 3.  RE: AdjustMonth function help needed

    Posted 01-23-2019 17:32
    Sheesh, something so simple. I was searching and searching for the answer. Thanks so much. It worked beautifully.


  • 4.  RE: AdjustMonth function help needed

    Posted 01-23-2019 17:37
    Here is a handy link to bookmark of all the functions with usage examples
    https://login.quickbase.com/db/6ewwzuuj?a=q&qid=1000132