Month Date year

[corbinap]

i am using this code in Month fields in two subreports with two different tables (One for 2006 and the other for 2007). The problem is that < Month(date) is OK for 2006 but not for 2007. Is a way to fix or add the year for the Month(date) to see the current year.

If txtinv1.Value > txtinv1.OldValue And 1 < Month(Date)

 

[PHV]

You may play with the Format function:
Format(Date, "yyyymm")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886