Unanswered: Need to find the date of the next saturday.
I am writting a select and I need to test to see if a termination date is >= to the previous saturday. For example, If today is November 2nd, I want to exclude any termination dates before saturday October 23rd. I can do this in oracle using the NEXT_DAY function (SEE BELOW)
SQL> select next_day(sysdate-15,'SAT') FROM DUAL;
where termdate >= next_day(sysdate-15,'SAT') and ...
Does access 97 have a function that would produce the same result that I could use in the where clause of a select?
Thanks for any help you can give me.
Last edited by beilstwh; 11-02-04 at 13:13.
You do not need a parachute to skydive. You only need a parachute to skydive twice.