handling incomplete dates

[Alan Harvey]

Ack, I'd forgotten that. I'll have to handle that as well. Thanks!

On Jan 9, 2008, at 10:20 AM, David Thompson wrote:

>> The person who originally entered the data dealt with
>>> this in a variety of ways ("0/4/32", "April 1932", etc.)
>
> Something else to keep in mind if you are still considering
> converting this field to a date field is that the year 2032 is closer
> to today's date than 1932, and with international settings set for
> the United States, the second number is the day of the month, so
> changing "0/4/32" to "1/4/32" would give you a date that Panorama
> wouldn't consider to be problematic, but it would be interpreted as
> January 4, 2032.
>
> Dave
> _______________________________________________
> Qna mailing list
> Qna at provue.com
> http://provue.com/mailman/listinfo/qna
>