How do I format dates to accomodate birth years prior to 1930?

S

Sharon

My patient Database tracks birth year and date before 1930. What is the
simplest way to have years in both centuries (birthdate entered on a form)?
 
T

Tom van Stiphout

On Thu, 9 Apr 2009 18:16:01 -0700, Sharon

Use 4-digit years. Enforce it with a validation rule or input mask.

-Tom.
Microsoft Access MVP
 
S

Sharon

So would the rule or input mask be on the control properties in the form?
I am using short date format, is there a standard format that would work?
 
S

Sharon

Thanks for the help Tom. I was succesful in using an input mask on the
control's properties in the form and I now have the ability to enter any
date. I actually did an expression: =>12/31/1889 and <12/21/2050
I was hoping to limit the dates to that range, thoughts?
Sharon
 
J

John W. Vinson

Thanks for the help Tom. I was succesful in using an input mask on the
control's properties in the form and I now have the ability to enter any
date. I actually did an expression: =>12/31/1889 and <12/21/2050
I was hoping to limit the dates to that range, thoughts?

For safety I'd delimit the dates with #:

=>#12/31/1889# and <#12/21/2050#

Access might interpret this as a division calculation.

Why the rather odd 2050 date? Capricorns are ok but Sagittarians aren't? <g>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top