Query subtracting 2 months

[OddProject]

I have a query and I need the last feild to subtract 2 months (or 60 days) from a date specified in a different feild.

eg. Query 1

ID: R5345
Start: 01/03/2010
Calculation feild = 01/01/2010

I just keep forgetting simple things...

Many thanks guys

 

[boblarson]

Use DateAdd function

MyCalcFieldNameateAdd("m",2,[Start])

 

[OddProject]

Thanks alot mate!

 

[boblarson]

Use DateAdd function

MyCalcFieldNameateAdd("m",2,[Start])

Oops, you said SUBTRACT. So, you would change the 2 to -2:

MyCalcFieldNameateAdd("m",-2,[Start])

 

[OddProject]

Yeah, way ahead of ya

Thanks!

 

[boblarson]

Yeah, way ahead of ya

Thanks!

I figured you might but I wanted to make sure to post the correct answer for anyone in the future