Formula for a date 2 weeks previous

Question

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

markshnier__you · Answer

Try thisAdjustMonth([Start Date]), -2)------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commarkshnier2@gmail.com------------------------------

markshnier__you · Answer

Note, I edited the above after posting to -2.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
[email protected]
------------------------------

ryanstanford1 · Answer

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 · Answer

Indeed you are correct. &nbsp;Should be.&nbsp;[start date] - Weeks(2)------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commarkshnier2@gmail.com------------------------------

rachelcohen1 · Answer

Thank you both. I now have a 2 weeks prior date, and a check box I’m hoping to use as a trigger for a reminder or a notification (preferred). Is there a way to use the checkbox as a trigger even if the record is not modified? I hope that makes sense. Rachel Sent from my iPhone------Original Message------Indeed you are correct. &nbsp;Should be.&nbsp;[start date] - Weeks(2)------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commarkshnier2@gmail.com------------------------------

Forum Discussion

Formula for a date 2 weeks previous

6 Replies

Related Content

QrewTip: Formula Logic Order

Previous and Next Record Buttons

Code Page Formula Button

Capture Previous values using Formula URL button & Pipeline

A way to look up a previous Record ID's [Date Created] Field