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

Entering a Date/Time parameter?

P: n/a
I am having a bad day for thought, and I can't remember how to create a
function that will return a date/time. I have a query with a date field in
"mm/dd/yyyy hh:nn:ss am/pm" format. If I enter the criteria as ">[Date1] and
< [Date2]", all's well. I want to create a function to pass the parameter
instead, but I can't remember how to do a simple thing like returning a
given date + a given time. For example, I want the [Date1] param to be
yesterday's date at 11:59:59 PM, so how would I pass this to the function. I
know this should be basically simple, so perhaps I should also ask, "WHAT
THE HECK IS WRONG WITH ME TODAY", but I'll have to ask for mercy when you
answer that one.

Thanks in advance.
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.