By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,078 Members | 1,280 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,078 IT Pros & Developers. It's quick & easy.

need help in date code..find all product that expired in the month

P: n/a
i need some code that show me all the expired product that i have in
every month
example:
the date today is 4/11/05 i need that it will show me all the proudct
that there dates betwenn 1/11/05 and 31/11/05
and it will be universal code for all the month not a specific month

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On 4 Nov 2005 18:12:03 -0800, to*********@nana.co.il wrote:
i need some code that show me all the expired product that i have in
every month
example:
the date today is 4/11/05 i need that it will show me all the proudct
that there dates betwenn 1/11/05 and 31/11/05
and it will be universal code for all the month not a specific month

For all the records of the current month:

Where Format(YourTable.DateField,"mm/yyyy") = Format(Date(),"mm/yyyy")
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.