List:General Discussion« Previous MessageNext Message »
From:Joey Date:March 29 2007 1:45pm
Subject:Help With a Week ( date ) query
View as plain text  
Hi Guys,

I'm kind of at a standstill in coming up with how to get a query I need to
write.
I'm trying to find a record which matches the week we are in.
Example today is Thursday the 29th, it is within the week which has the 26th
through the 1st, and if the day is within this week display the record that
has the date 3/26/2007.

Basically we are returning a special which is dated each Monday, any day
within that week should show the Monday value.

I appreciate your help!

Joey




Thread
Help With a Week ( date ) queryJoey29 Mar
  • RE: Help With a Week ( date ) queryJerry Schwartz29 Mar
    • information_schema not foundCharles Brown29 Mar
      • Re: information_schema not foundPaul DuBois29 Mar
    • RE: Help With a Week ( date ) queryJim Ginn29 Mar
RE: Help With a Week ( date ) queryJerry Schwartz2 Apr