Date Criteria Problem

[gregork]

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

[Rick Brandt]

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

[Alan Webb]

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

[gregork]

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

[Rick Brandt]

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