How to subtract date

[d1004]

Let say on my form, I ask the user to select only the ending date for the report. Because I want to
control the input, I will compute for the begin quarter date. To do that I need to take the ending date
and subtract that by 3 months to get the begin date. For example: 7/1/2002 - ? = 4/1/2002. Do you know how i can do that? Thank you!

 

[Bastien]

=DateDiff("d", [OrderDate], [ShippedDate])

"d" equals days

Bastien

There are many ways to skin this cat,
but it still tastes like chicken

 

[Tarwn]

Mm, Date diff works if you know both dates, try DateAdd:

Dim myDate
myDate = DateAdd("m",-3,Now) 'add -3 months to Now

-Tarwn The three most dangerous things in the world are a programmer with a soldering iron, a hardware type with a program patch, and a user with an idea
-computer saying (Wiz Biz - Rick Cook)

 

[d1004]

Thank you, it works like a charm.