Date Retrieval

Bigced_21 · #1 (**permalink**) 05-15-03, 09:28

is there a way i can retrieve the last date of each month. For example, I'm designing a license that I want to expire at the end of the birth month for an individual?

Any suggestions, Please help?

Memnoch1207 · #2 (**permalink**) 05-15-03, 15:14

you can use a select case statement

Code:

birthmonth = 12 (Dec)

Select Case birthmonth
     Case 1,3,5,7,8,10,12
          days = 31
     Case 4,6,9,11
          days = 30
     Case 2
          days = 28
End Select

Internet Services

Web Development

Digital Marketing

Consumer Tech