Hi

 

I'm struggling with some logic

 

I have a table called: submissions and each record has an approvedate field
which stores the date mm/dd/yyyy

 

 

I want to display all records for 7 days only from their  approved date so I
guess something like

 

 

Select * from submissions were approvedate  - this is were im getting stuck

 

 

Pointers appreciated, im sure its simple ?

 

Regards

 

John B

 

Reply via email to