Discussions

Expand all | Collapse all

Future Date Formula Help

  • 1.  Future Date Formula Help

    Posted 10 days ago
    I want to create at date that is X number of weeks after another date but if the date falls less than or equal to 3 day into any given month then the date should equal the last day of the prior month. What should this formula look like?

    ------------------------------
    George Bramhall
    ------------------------------


  • 2.  RE: Future Date Formula Help

    Posted 10 days ago
    3 business days or calendar days ?

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Future Date Formula Help

    Posted 10 days ago
    Calendar Days, thanks

    ------------------------------
    George Bramhall
    ------------------------------



  • 4.  RE: Future Date Formula Help

    Posted 10 days ago
    Try this

    var RawDate = [Another date] + Weeks([X weeks as a numeric field]);

    IF(Day($RawDate)<=3, LastDayOfMonth(AdjustMonth($RawDate,-1)),$RawDate)

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 5.  RE: Future Date Formula Help

    Posted 9 days ago
    works like a charm, thank you Mark!!

    ------------------------------
    George Bramhall
    ------------------------------



  • 6.  RE: Future Date Formula Help

    Posted 4 days ago
    Now my end user wants different results.
    If a date lands during the First week of the month, he wants to return the last day of the previous month. What is the best formula to achieve this?

    ------------------------------
    George Bramhall
    ------------------------------



  • 7.  RE: Future Date Formula Help

    Posted 4 days ago
    Can you define what you mean by the first week of the month?  Suppose the 1st of the month is a Thursday?  Which days are the first week of the month and also tell me about the Saturday and Sunday too.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 8.  RE: Future Date Formula Help

    Posted 4 days ago
    Ahh, Should have been more specific. First week of the Calendar Month (including weekends).  Same applies to the result, Last day of the previous calendar Month. This is a billing date.

    ------------------------------
    George Bramhall
    ------------------------------



  • 9.  RE: Future Date Formula Help

    Posted 4 days ago
    Sorry,
    You need to dumb it more down for me.  Suppose the month in question was May 2020.  Which specific date are in the first week of May 2020.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 10.  RE: Future Date Formula Help

    Posted 4 days ago
    May 1 and May 2.

    ------------------------------
    George Bramhall
    ------------------------------



  • 11.  RE: Future Date Formula Help

    Posted 4 days ago
    Not tested,  but try this

    var RawDate = [Another date] + Weeks([X weeks as a numeric field]);

    IF($RawDate) <= LastDayOfWeek(FirstDayOfMonth($RawDate)), LastDayOfMonth(AdjustMonth($RawDate,-1)),$RawDate)

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------