Comparing Months

[MrsNic]

I want to compare a date with today's date and if the month is greater to put a Yes in a text box, if not no.

I have tried the Iff function and DateDiff but I don't seem to be getting the syntax correct.

Any help gratefully received.

Cath

 

[RuralGuy]

Where are you doing the comparing? In a query? In event code in a form? Does the year make any difference?

HTH RuralGuy (RG for short) acXP winXP Pro
Please respond to this forum so all may benefit

 

[nickdel]

try this:

IIf(CDate(Me.Text1.Value) = Date, "True", "False")

Cheers

Nick

 

[nickdel]

I should maybe expand slightly on my example!!:

Dim CheckIt

CheckIt = IIf(CDate(Me.Text1.Value) = Date, "True", "False")

Me.Text2.Value = CheckIt

Cheers

Nick

 

[TheAceMan1]

How are ya MrsNic . . .

Perhaps this:

[blue]= IIf(Month(CDate(Me.Text1.Value)) > Month(Date), "True", "False")[/blue]

See Ya! . . . . . .