FromDate should be 3 months ago

[scoobydoo987]

Does anyone know how I would fix this? FromDate is coming up as "2/9/2006" and should be "10/9/2005" The problem probably is Year(Now()) but I am not sure.

FromDate = Month(Now()) - 3 & "/" & Day(Now()) & "/" & Year(Now())

[Easy_Coder]

Have you tried something like this?

ToDate = Now()
FromDate = (Now() - 3)

You can also look at the datediff function. Just google datediff.

[scoobydoo987]

thanks

[mattglet]

FromDate = DateValue(Month(Now()) - 3 & "/" & Day(Now()) & "/" & Year(Now()))

This will also work. I think you're having problems with string to date conversion.

[TheNige]

If this is .Net just use builtin functions

Dim myDate As Date = CType("2/9/2006", Date)
myDate.AddMonths(-3).ToShortDateString()