date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Trying to learn how to write macros. I have a macro currently pulling in a
set of data from a database for the current date. My manager wants to see
data for the last week given the current day. How do i do that.
 
Use the BETWEEN function - depending on the dbase, syntax
varies

SELECT data from database
WHERE datefield=BETWEEN #2/10/2004# and #2/17/2004#

HTH
Devin
 
I dont know what happened with my previous update....

With that below, i have to specify a date....is there any other function i
can use that doesnt specify a date range...like where current_day() - 7 or
something...

thanks for the help
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA code relative to current date 5
Macro for Dates 5
Date question 4
Excel Monthly Spread sheet. 12
switch to another worksheet, then return to original sheet 2
Date find Macro 3
Date parameters 3
Hosting photos on own server: what are the pros and cons here? 0

Back
Top