Forum Discussion

RachelCohen1's avatar
RachelCohen1
Qrew Trainee
6 years ago

Formula for a date 2 weeks previous

Hi, I have a formula-date field to get a date a month before: AdjustMonth(ToDate(ToText([Start Date])), -1) I would like to have a date that is only 2-weeks before [Start Date]. Any thoughts? ...
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
Try this

AdjustMonth([Start Date]), -2)

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    6 years ago
    Note, I edited the above after posting to -2.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    markshnier2@gmail.com
    ------------------------------
    • RyanStanford1's avatar
      RyanStanford1
      Qrew Captain
      6 years ago
      Hey Mark,

      The OP is asking for 2 weeks prior to [Start Date], if I'm reading your answer right, wouldn't that be two months prior to [Start Date]?

      ------------------------------
      Ryan Stanford
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        6 years ago
        Indeed you are correct.  Should be. 

        [start date] - Weeks(2)

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