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

MarkShnierYou · Answer

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

Sign up

Login to the community