Date Format - Credit Card Expiry

Hi, This should be simple for you guys.

We need to record credit card details including "Expiry Date" in the form of
"DD/YY".

How do we best format the field for easy entry AND validation (i.e. as a
date field and not just as a text field) without having to enter anything
other than just the month and year and with the result not showing up as
day, month year?

Please help as it is driving me nuts.

Don't use a date field, use a string and validate the format are you sure
it's DD/YY rather than MM/YY, the other thing would be use a date field and
always set the day to 01 because you never need it, it should not be a
problem and on your screen always display MM/YY so dropping the day portion
on the screen and any reports.


--
Regards

Alex White MCDBA MCSE
http://www.intralan.co.uk

"John Smith" wrote in message
...
Hi, This should be simple for you guys.

We need to record credit card details including "Expiry Date" in the form
of "DD/YY".

How do we best format the field for easy entry AND validation (i.e. as a
date field and not just as a text field) without having to enter anything
other than just the month and year and with the result not showing up as
day, month year?

Please help as it is driving me nuts.

I guess it would help if I could type - yes I do mean MM/YY of course.

Can you explain what you mean by "always set the day to 01" how do I do this
in the table design or is this effected in the form?

Thanks for helping.

"Alex White MCDBA MCSE" wrote in message
...
Don't use a date field, use a string and validate the format are you sure
it's DD/YY rather than MM/YY, the other thing would be use a date field
and always set the day to 01 because you never need it, it should not be a
problem and on your screen always display MM/YY so dropping the day
portion on the screen and any reports.


--
Regards

Alex White MCDBA MCSE
http://www.intralan.co.uk

"John Smith" wrote in message
...
Hi, This should be simple for you guys.

We need to record credit card details including "Expiry Date" in the form
of "DD/YY".

How do we best format the field for easy entry AND validation (i.e. as a
date field and not just as a text field) without having to enter anything
other than just the month and year and with the result not showing up as
day, month year?

Please help as it is driving me nuts.

Hi John,

I have done a bit of testing I think using the date field type is not going
to yield the results you want, either use a text field type with a length of
4 with a format of "99/99" and an input mask of 99/99 or think about
splitting the month and year into 2 different fields, 1 for month and 1 for
year both text length 2,

--
Regards

Alex White MCDBA MCSE
http://www.intralan.co.uk

"John Smith" wrote in message
...
I guess it would help if I could type - yes I do mean MM/YY of course.

Can you explain what you mean by "always set the day to 01" how do I do
this in the table design or is this effected in the form?

Thanks for helping.

"Alex White MCDBA MCSE" wrote in message
...
Don't use a date field, use a string and validate the format are you sure
it's DD/YY rather than MM/YY, the other thing would be use a date field
and always set the day to 01 because you never need it, it should not be
a problem and on your screen always display MM/YY so dropping the day
portion on the screen and any reports.


--
Regards

Alex White MCDBA MCSE
http://www.intralan.co.uk

"John Smith" wrote in message
...
Hi, This should be simple for you guys.

We need to record credit card details including "Expiry Date" in the
form of "DD/YY".

How do we best format the field for easy entry AND validation (i.e. as a
date field and not just as a text field) without having to enter
anything other than just the month and year and with the result not
showing up as day, month year?

Please help as it is driving me nuts.

Some things just aren't simple are they.

I can see your point of a text field (length 4 or 5 to accomodate the "/"
?).

I would then need to validate the last two characters against the current
year and then possibly the first two against the current month.

Thanks for all your input.

"Alex White MCDBA MCSE" wrote in message
...
Hi John,

I have done a bit of testing I think using the date field type is not
going to yield the results you want, either use a text field type with a
length of 4 with a format of "99/99" and an input mask of 99/99 or think
about splitting the month and year into 2 different fields, 1 for month
and 1 for year both text length 2,

--
Regards

Alex White MCDBA MCSE
http://www.intralan.co.uk

"John Smith" wrote in message
...
I guess it would help if I could type - yes I do mean MM/YY of course.

Can you explain what you mean by "always set the day to 01" how do I do
this in the table design or is this effected in the form?

Thanks for helping.

"Alex White MCDBA MCSE" wrote in message
...
Don't use a date field, use a string and validate the format are you
sure it's DD/YY rather than MM/YY, the other thing would be use a date
field and always set the day to 01 because you never need it, it should
not be a problem and on your screen always display MM/YY so dropping the
day portion on the screen and any reports.


--
Regards

Alex White MCDBA MCSE
http://www.intralan.co.uk

"John Smith" wrote in message
...
Hi, This should be simple for you guys.

We need to record credit card details including "Expiry Date" in the
form of "DD/YY".

How do we best format the field for easy entry AND validation (i.e. as
a date field and not just as a text field) without having to enter
anything other than just the month and year and with the result not
showing up as day, month year?

Please help as it is driving me nuts.

John:

Personally, I have done this with TWO text fields. I created a drop down
list for the 12 months and a drop-down list for the next 15 years.



--
Rick B



"John Smith" wrote in message
...
Some things just aren't simple are they.

I can see your point of a text field (length 4 or 5 to accomodate the "/"
?).

I would then need to validate the last two characters against the current
year and then possibly the first two against the current month.

Thanks for all your input.

"Alex White MCDBA MCSE" wrote in message
...
Hi John,

I have done a bit of testing I think using the date field type is not
going to yield the results you want, either use a text field type with a
length of 4 with a format of "99/99" and an input mask of 99/99 or think
about splitting the month and year into 2 different fields, 1 for month
and 1 for year both text length 2,

--
Regards

Alex White MCDBA MCSE
http://www.intralan.co.uk

"John Smith" wrote in message
...
I guess it would help if I could type - yes I do mean MM/YY of course.

Can you explain what you mean by "always set the day to 01" how do I do
this in the table design or is this effected in the form?

Thanks for helping.

"Alex White MCDBA MCSE" wrote in message
...
Don't use a date field, use a string and validate the format are you
sure it's DD/YY rather than MM/YY, the other thing would be use a date
field and always set the day to 01 because you never need it, it
should
not be a problem and on your screen always display MM/YY so dropping
the
day portion on the screen and any reports.


--
Regards

Alex White MCDBA MCSE
http://www.intralan.co.uk

"John Smith" wrote in message
...
Hi, This should be simple for you guys.

We need to record credit card details including "Expiry Date" in the
form of "DD/YY".

How do we best format the field for easy entry AND validation (i.e.
as
a date field and not just as a text field) without having to enter
anything other than just the month and year and with the result not
showing up as day, month year?

Please help as it is driving me nuts.

I think that is the way to go......

--
Regards

Alex White MCDBA MCSE
http://www.intralan.co.uk

"Rick B" Anonymous wrote in message
...
John:

Personally, I have done this with TWO text fields. I created a drop down
list for the 12 months and a drop-down list for the next 15 years.



--
Rick B



"John Smith" wrote in message
...
Some things just aren't simple are they.

I can see your point of a text field (length 4 or 5 to accomodate the "/"
?).

I would then need to validate the last two characters against the current
year and then possibly the first two against the current month.

Thanks for all your input.

"Alex White MCDBA MCSE" wrote in message
...
Hi John,

I have done a bit of testing I think using the date field type is not
going to yield the results you want, either use a text field type with
a
length of 4 with a format of "99/99" and an input mask of 99/99 or
think
about splitting the month and year into 2 different fields, 1 for month
and 1 for year both text length 2,

--
Regards

Alex White MCDBA MCSE
http://www.intralan.co.uk

"John Smith" wrote in message
...
I guess it would help if I could type - yes I do mean MM/YY of course.

Can you explain what you mean by "always set the day to 01" how do I
do
this in the table design or is this effected in the form?

Thanks for helping.

"Alex White MCDBA MCSE" wrote in message
...
Don't use a date field, use a string and validate the format are you
sure it's DD/YY rather than MM/YY, the other thing would be use a
date
field and always set the day to 01 because you never need it, it
should
not be a problem and on your screen always display MM/YY so dropping
the
day portion on the screen and any reports.


--
Regards

Alex White MCDBA MCSE
http://www.intralan.co.uk

"John Smith" wrote in message
...
Hi, This should be simple for you guys.

We need to record credit card details including "Expiry Date" in the
form of "DD/YY".

How do we best format the field for easy entry AND validation (i.e.
as
a date field and not just as a text field) without having to enter
anything other than just the month and year and with the result not
showing up as day, month year?

Please help as it is driving me nuts.