Results 1 to 3 of 3

Thread: Help on Dates

  1. 02-28-2003, 02:51 PM #1
    yashiro
    yashiro is offline Registered User
    Join Date
    Feb 2003
    Posts
    2

    Help on Dates

    Hello, I'm in 10 grade right now and I have to do a database of a gym. I have done most of it except for the date thing.

    What I want to do is to display the expired memberships and I have no idea of what to do.

    Example> X person pays 1 month membership, and then 1 month passes and I want the database to recognize the person who haven't payed the membership.

    Thank you very much!
    Reply With Quote Reply With Quote
  2. 03-02-2003, 07:11 PM #2
    yashiro
    yashiro is offline Registered User
    Join Date
    Feb 2003
    Posts
    2
    any help? please
    Reply With Quote Reply With Quote
  3. 03-03-2003, 05:01 AM #3
    KUZANAGI
    KUZANAGI is offline Registered User
    Join Date
    Feb 2003
    Posts
    9
    Create a field in the table holding the membership commencement date, which indicates the length of their membership preferably in days. (ie 30 for 1 month). Then in a query add the membership length to the commencement date and this will give you the expiration date of the membership.

    IE

    ExpirationDate: [StartDate] + [MembershipLength]
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules