Future Due Date

  • Thread starter Thread starter soccerelf
  • Start date Start date
S

soccerelf

I am trying to create a query that will search one table for pending tasks
that are due within the next 7 days. The column Due Date input mask is set
to 00\->L<LL\-00;0;_ . Any suggestions on what will allow me to search my
table for all responsive dates from 12-Dec-07 to 18-Dec-07 would be
appreciated. Thank you
 
The column Due Date input mask is set to 00\->L<LL\-00;0;_ .
This leads me to believe that your Due Date field is a text field. You
need to change it to a DateTime datatype.
Then use a criteria of --- <=Date() +7
 
Back
Top