2 Replies Latest reply on Apr 19, 2007 7:44 AM by Dan Bracuk

Show only records from last month

Mr_Pappy Apr 19, 2007 6:58 AM

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

1. Re: Show only records from last month

tclaremont Apr 19, 2007 7:12 AM (in response to Mr_Pappy)

SELECT *
FROM tblProds
WHERE DateUploaded >= DateAdd("m",-1,Now())
Like Show 0 Likes(0)

Actions
2. Re: Show only records from last month

Dan Bracuk Apr 19, 2007 7:44 AM (in response to tclaremont)

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().
Like Show 0 Likes(0)

Actions

Go to original post