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

Date Criteria Problem

P: n/a
I have a query to return records within a date range. I have a prompt to
enter a start and end date which works fine as long as I enter the date in
mm/dd/yy format (even though the date field is in dd/mm/yy format). Problem
is I want to enter the date in the prompt as dd/mm/yy. How and where do I
format the prompt entry to dd/mm/yy ?

Greg
Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
gregork wrote:
I have a query to return records within a date range. I have a prompt
to enter a start and end date which works fine as long as I enter the
date in mm/dd/yy format (even though the date field is in dd/mm/yy
format). Problem is I want to enter the date in the prompt as
dd/mm/yy. How and where do I format the prompt entry to dd/mm/yy ?

Greg


When explicitly used in a query you must use US format or a non-ambiguous format
(either ISO or one where the month uses characters). That is unless you want to
parse it and convert it.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #2

P: n/a
Gregork,
Me thinks this is one case where designing & coding your own dialog box make
sense. You can put your date validation code in the dialog box.

"gregork" <gr*****@paradise.net.nz> wrote in message
news:41********@clear.net.nz...
I have a query to return records within a date range. I have a prompt to
enter a start and end date which works fine as long as I enter the date in
mm/dd/yy format (even though the date field is in dd/mm/yy format).
Problem
is I want to enter the date in the prompt as dd/mm/yy. How and where do I
format the prompt entry to dd/mm/yy ?

Greg

Nov 13 '05 #3

P: n/a
Thaks for the replies. Dialog box sounds good.....where would I find one of
those? (newbie)

greg

"Alan Webb" <kn*****@hotmail.com> wrote in message
news:E5********************@comcast.com...
Gregork,
Me thinks this is one case where designing & coding your own dialog box make sense. You can put your date validation code in the dialog box.

"gregork" <gr*****@paradise.net.nz> wrote in message
news:41********@clear.net.nz...
I have a query to return records within a date range. I have a prompt to
enter a start and end date which works fine as long as I enter the date in mm/dd/yy format (even though the date field is in dd/mm/yy format).
Problem
is I want to enter the date in the prompt as dd/mm/yy. How and where do I format the prompt entry to dd/mm/yy ?

Greg


Nov 13 '05 #4

P: n/a
gregork wrote:
Thaks for the replies. Dialog box sounds good.....where would I find
one of those? (newbie)


What Alan meant was that you create your own *form* for entering the criteria
and have the query pull its criteria from the form.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.