If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
dates
hi everyone!
does anyone know how to filter a recordset for a specific date. for example. i keep some dates in an access database of cpr training. i am making a repeating region listing the people whose cpr license will expire in 30 days. well how do you construct that kind of sql sentence SELECT* FROM table WHERE cprduedate = what i'm completely lost! i keep dates in form mm/dd/yyyy and am using asp. thanks a bunch in advance |
#2
|
|||
|
|||
dates
You have to delimit the date string with # signs:
WHERE cprduedate = #mm/dd/yyyy# -- Regards, Adrian Jansen J & K MicroSystems Microcomputer solutions for industrial control wrote in message hlink.net... hi everyone! does anyone know how to filter a recordset for a specific date. for example. i keep some dates in an access database of cpr training. i am making a repeating region listing the people whose cpr license will expire in 30 days. well how do you construct that kind of sql sentence SELECT* FROM table WHERE cprduedate = what i'm completely lost! i keep dates in form mm/dd/yyyy and am using asp. thanks a bunch in advance |
#3
|
|||
|
|||
dates
Don't know if this will work in asp though
WHERE (DateDiff("d",Now(),[cprduedate]))30 Regards Grant wrote in message hlink.net... hi everyone! does anyone know how to filter a recordset for a specific date. for example. i keep some dates in an access database of cpr training. i am making a repeating region listing the people whose cpr license will expire in 30 days. well how do you construct that kind of sql sentence SELECT* FROM table WHERE cprduedate = what i'm completely lost! i keep dates in form mm/dd/yyyy and am using asp. thanks a bunch in advance |
Thread Tools | |
Display Modes | |
|
|