Preform a IF THEN ELSE based on what the current MONTH is

[Andrew Andromeda]

HI guys

i want to add a nice "easter egg" into my program, on the main menu form i want a image of santa to appear if the current month is equal to december.

Im not sure how i would extract the MONTH part out of say a NOW statement.

Any clues?

this would need to happen every time december rolls around.

should i look at filling a text box with the now statement, then useing the LEFT RIGHT MID options to find what the month is, and if its 12 then display my image?
i would prefer something rather simple with out the need to add more textboxes etc.

cheers.

[alansidman]

=month(now()) will give you 12 for any date in December.

[Andrew Andromeda]

thank you that worked a treat!