Skip to main content
Inspiring
April 19, 2007
Question

Show only records from last month

  • April 19, 2007
  • 1 reply
  • 330 views
Hi

Help me pleeeeze!!

I have a products table (tblProds)
It has a field called DateUploaded

I want to only display records which are less or equal than a month old.

PLEEEEZE can someone help me here...
I dont know if I'm just being doff...

Thanks again chaps and ladies.

Regards
Paps
This topic has been closed for replies.

1 reply

tclaremont
Inspiring
April 19, 2007
SELECT *
FROM tblProds
WHERE DateUploaded >= DateAdd("m",-1,Now())
Inspiring
April 19, 2007
quote:

Originally posted by: tclaremont
SELECT *
FROM tblProds
WHERE DateUploaded >= DateAdd("m",-1,Now())

I believe octothorps are required. Also, you have to do something about the time portion of now().