date(month(DateField), day(DateField), year(DateField)+100),
This will obviously take any year before 1920 and add a century to it.
If you might legitimately have data with the year 1920, then you'll need
to find the year cutoff that works for you.
Carl Mittler wrote:~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~> I need to convert a Text field containing both auto and manually entered
> dates over to a Date field. The records that were autoentered move over
> without a problem. But those that were edited or entered manually using a
> two digit year do not. For example: 1/25/02 converts to 1/25/1902. Is
> there any workaround to solve this problem short of manually correcting the
> converted data.
Howard Schlossberg (818) 883-2846
FM Pro Solutions Los Angeles, California
Associate Member, FileMaker Solutions Alliance