This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hi There,
I have a date field (name = Contract Start) with a simple dd/mm/yy.
In a new field (name= Order Date), I would like a formula to create a date that is six weeks prior to the date in the ‘Contract Start’ field.
I have tried this: DATEADD(Co...
Hi Scott, many thanks. Yep, it was the quotes. This is the one that worked as you advised:
DATEADD({Contract Start},-6,“week”)
In formating I removed the time field and worked perfectly with the new date.
Thanks again Scott!
Rob
