Results 1 to 2 of 2

Thread: Date Retrieval

  1. #1
    Join Date
    Dec 2002
    Location
    KY
    Posts
    56

    Red face Unanswered: Date Retrieval

    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?

  2. #2
    Join Date
    Jan 2003
    Location
    Midwest
    Posts
    138
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •