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

  • Thread starter Thread starter Sharon
  • Start date Start date
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)?
 
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
 
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?
 
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
 
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?
Click to expand...

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>
 
Back
Top