Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Query help?

Quote Reply
Query help?
I am having trouble writing a query that will do the following (any help would be appreciated):

I have a membership database with a field called "date_exp" and a field called "Member" which contains a "Yes" or "No". What I am trying to do is print out a message to let the member know whenever they login if their membership will expire within the next 30 days.

I know I can write an "if" statement to take care of determining if they are a member or not. But I am having a problem coming up with a query for the "date_exp" that will work for comparing the date_exp against current date at an INTERVAL 1 MONTH and against the members membership expiration date = "date_exp" that is currently logged in.

I hope I explained this well enough?

Any help getting me started in the right direction would be great !
Subject Author Views Date
Thread Query help? donm 3646 Nov 26, 2001, 2:47 PM
Thread Re: [donm] Query help?
jean 3573 Nov 26, 2001, 4:36 PM
Thread Re: [jean] Query help?
donm 3579 Nov 26, 2001, 5:01 PM
Thread Re: [donm] Query help?
jean 3581 Nov 26, 2001, 5:54 PM
Thread Re: [jean] Query help?
donm 3548 Nov 26, 2001, 6:02 PM
Post Re: [donm] Query help?
donm 3561 Nov 28, 2001, 11:07 AM
Thread Re: [jean] Query help?
Reena0330 3312 Sep 10, 2002, 1:33 PM
Thread Re: [Reena0330] Query help?
jean 3306 Sep 10, 2002, 1:59 PM
Post Re: [jean] Query help?
Reena0330 3319 Sep 12, 2002, 11:10 AM
Post Re: [jean] Query help?
Reena0330 3360 Aug 15, 2002, 1:53 PM