Hi all,

In field I date format dd/mmm/yy and input mask : 99/99/00;0;_.
So if user put 23/07/02 or 07/23/02 is gonna have same results 23/jul/02
.How to make that only first way (day,month,year) to be acceptable.
Thanks
Fule

I am not sure how to solve your problem of an incorrect date being entered 
but I believe you need to set your regional settings for short date to get 
the day,month,year order. However, it will still read 23/07/02 and 
07/23/02 as 23/Jul/02 because there is no 23rd month. However, 01/05/02 
will be read as 01/May/02 not 05/Jan/02 if your short date format is 
regionally set to dd/mm/yy.

Don't know if this will help or not.

Amy

> Hi all,

In field I date format dd/mmm/yy and input mask : 99/99/00;0;_.
So if user put 23/07/02 or 07/23/02 is gonna have same results 23/jul/02
.How to make that only first way (day,month,year) to be acceptable.
Thanks
Fule

Amy,
but what if user put by mistake 07/06/02 in steed of 06/07/02?
how to control this?
Fule

-----Original Message-----
From: Amy Wyatt [mailto:amyw@c...]
Sent: Monday, July 29, 2002 4:12 PM
To: Access
Subject: [access] Re: date format


I am not sure how to solve your problem of an incorrect date being entered 
but I believe you need to set your regional settings for short date to get 
the day,month,year order. However, it will still read 23/07/02 and 
07/23/02 as 23/Jul/02 because there is no 23rd month. However, 01/05/02 
will be read as 01/May/02 not 05/Jan/02 if your short date format is 
regionally set to dd/mm/yy.

Don't know if this will help or not.

Amy

> Hi all,

In field I date format dd/mmm/yy and input mask : 99/99/00;0;_.
So if user put 23/07/02 or 07/23/02 is gonna have same results 23/jul/02
.How to make that only first way (day,month,year) to be acceptable.
Thanks
Fule

Fule,

	I don't believe there is any way to control User error to that degree.  How
is the program supposed to know that 07/06/02 is wrong and 06/07/02 is
right?  Are there other conditions that would have any bearing on a valid
date in your program?  Is the date always the current date, perhaps?  If the
date itself is independent of other factors then there is no way to check if
it is correct, only if it is a valid date data type.  If it is dependent on
other factors, then theoretically, you could check it against those factors
before accepting the data.  But I'd have to know what those factors were
before I could give specific examples.

Andrew

-----Original Message-----
From: Nikola [mailto:Nikola@B...]
Sent: Tuesday, July 30, 2002 1:20 PM
To: Access
Subject: [access] Re: date format


Amy,
but what if user put by mistake 07/06/02 in steed of 06/07/02?
how to control this?
Fule

-----Original Message-----
From: Amy Wyatt [mailto:amyw@c...]
Sent: Monday, July 29, 2002 4:12 PM
To: Access
Subject: [access] Re: date format


I am not sure how to solve your problem of an incorrect date being entered
but I believe you need to set your regional settings for short date to get
the day,month,year order. However, it will still read 23/07/02 and
07/23/02 as 23/Jul/02 because there is no 23rd month. However, 01/05/02
will be read as 01/May/02 not 05/Jan/02 if your short date format is
regionally set to dd/mm/yy.

Don't know if this will help or not.

Amy

> Hi all,

In field I date format dd/mmm/yy and input mask : 99/99/00;0;_.
So if user put 23/07/02 or 07/23/02 is gonna have same results 23/jul/02
.How to make that only first way (day,month,year) to be acceptable.
Thanks
Fule

Fule,

<< but what if user put by mistake 07/06/02 in steed of 06/07/02?
how to control this? >>

One way to control this is to have the users enter the day, month, and 
year in three separate unbound text boxes that are clearly labeled.  Then 
you store the whole date by putting the three parts together yourself and 
writing it into a fourth (unseen) bound textbox on the form.

For me, I would just have the one textbox and make sure there are clear 
instructions visible on the label.  For example:

                 ---------
Date (dd/mm/yy): |       |
                 ---------

Or put this label at the top of all forms with dates:  "Please enter all 
dates in the format Day / Month / Year".

Greg