Converting a date into the month

[cliffk]

Hello everyone,

This is the first time I am posting here, and hope I can explain what I want to do.

I have an expiration date and I want to compare to the current month. If they agree, then I want to put a warning that the expiration date is coming up. I've learned about Month(Now()) and DatePart(mm,x). Don't know if I need these to get the answer I want.

Thanks for the help!
Cliff

[sanniep]

Hello everyone,

This is the first time I am posting here, and hope I can explain what I want to do.

I have an expiration date and I want to compare to the current month. If they agree, then I want to put a warning that the expiration date is coming up. I've learned about Month(Now()) and DatePart(mm,x). Don't know if I need these to get the answer I want.

Thanks for the help!
Cliff

Try the following expression: iif(Datepart("m";Now();2;2)=Datepart("m";[Expiration Date];2;2);"Experation date is coming up!";"")

The datepart expression formats the current systemdate and your (date/time formatted) Experation Date field to monthnumbers. The variables 2;2 represent the format of the year and first week of the year. Take a look at the datepart-help to read about this variables

The iif matches systemdate and experation date, if they match the field will display "Experation date is coming up", field stays empty when they don't match.

Grtz, Sander

[cliffk]

Hi

Thanks for the quick response. Excuse my ignorance, but what does the 2;2 do in the formula?

Thanks again
Cliff

[sanniep]

Hi

Thanks for the quick response. Excuse my ignorance, but what does the 2;2 do in the formula?

Thanks again
Cliff

That's to let the expression know what you want defined as the first day of the week and how your year starts:

First 2: monday is the first day of the week (over here in Holland it is)
Second 2: week 1 is the week which contains at least 4 days of the new year

Look into the Access-Help and check the datepart-function variables to see the options!

Regards, Sander

[PEB]

Hi,
those are the first day of the week and the first day of the year!

See them!

The firstdayofweek argument has these settings:

Constant Value Description
vbUseSystem 0 Use the NLS API setting.
vbSunday 1 Sunday (default)
vbMonday 2 Monday
vbTuesday 3 Tuesday
vbWednesday 4 Wednesday
vbThursday 5 Thursday
vbFriday 6 Friday
vbSaturday 7 Saturday



The firstweekofyear argument has these settings:

Constant Value Description
vbUseSystem 0 Use the NLS API setting.
vbFirstJan1 1 Start with week in which January 1 occurs (default).
vbFirstFourDays 2 Start with the first week that has at least four days in the new year.
vbFirstFullWeek 3 Start with first full week of the year.

[cliffk]

Thank you for all the help! Loving this discussion group!

Cliff