Discussion Locked

Date Range Report

0 helpful

1 reply

by artform Jun 2, 2004 last reply Jun 7, 2004

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a table with a field with a date in the 01/01/2004 format. What is the code to select this field and specify a date range of 1 week.

1 reply

SELECT * FROM tbl WHERE dateintable between #01/01/2004# and #01/08/2004#;

This discussion is closed to new replies.