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?

Thanks,
Rachel



------------------------------
Rachel C
------------------------------
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
        ------------------------------