Forum Discussion

RachelCohen1's avatar
RachelCohen1
Qrew Trainee
5 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?

Thanks,
Rachel



------------------------------
Rachel C
------------------------------
Formulas and functions

6 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    5 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
      Qrew Champion
      5 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
        5 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
        ------------------------------