Converting a text field to a date field - FM6

[Carl Mittler]

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.
Thanks
Carl

[Howard Schlossberg]

if(
year(DateField)<1920,
date(month(DateField), day(DateField), year(DateField)+100),
DateField)

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.
> Thanks
> Carl

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg (818) 883-2846
FM Pro Solutions Los Angeles, California
Associate Member, FileMaker Solutions Alliance

[manet]

Carl Mittler <cmdesk@optonline.net> wrote:

> Is
> there any workaround to solve this problem short of manually correcting the
> converted data.

a calculated "replace all" inserting "20" if the omega-3 character is
"/"

to test carefully !
--
Philippe Manet