Putting the current date in a variable 1

[Nomad0803]

I'm trying to reference the current month in an If statement in the Fetch() function, but I can't find an example of the syntax and everything I've tried gives me an error. Does anyone have any examples of the syntax for doing this.

Thanks,
Nomad0803

 

[ASG0856]

Have you tried

Dim CurrMonth as String

CurrMonth = Format$(Now(),"mmmm")

which should return the full month name

 

[ASG0856]

Or
If you want a month number

Dim CurrMonth As Integer

CurrMonth = DatePart("m",Now())