Minus Date

[Gismo]

Hi,

How do I calculate in a query to subtract 12 days from a date (YYYY/MM/DD) ?

 

[arnelgp]

DateAdd("d",-12, Date())

or

DateAdd("d",-12, [dateField])

 

[theseus]

You could use DateSerial. Something like

=DateSerial(Year([StartDate]),Month([StartDate]),Day([StartDate])-12)

 

[CJ_London]

or just

Date()-12

or

[myateField]-12

 

[Gismo]

Hi, sorry, I meant to as for -12 months, not days

 

[isladogs]

Use arnel's code from post 2 but use "m" instead of "d"

 

[CJ_London]

or use "yyyy" and -1

@Theseus - don't think your code would work

if startdate was say 3rd of month, Day(Startdate)-12 would give you -9