Change or correct the year in a date field?

Is there a fairly straight forward way to correct the 'year' in a date
field, (in FM3,believe it or not)?

In many of the records, the year is showing '1995', where it should be
showing '2005'...

The date format is showing '1/4/05', but when I click in some of the
records, the date expands to show '1/4/1905' in some records, and it shows
as 'x/x/2005' in other records. They should all be 'x/x/2005'. How can I
correct this database to have all the years change to 2005?

Thanks.

-Dennis

--
Dennis Kessler
http://www.denniskessler.com/acupuncture

Re: Change or correct the year in a date field?

On Sep 2, 8:19 am, dk_ wrote:
> Is there a fairly straight forward way to correct the 'year' in a date
> field, (in FM3,believe it or not)?
>
> In many of the records, the year is showing '1995', where it should be
> showing '2005'...
>
> The date format is showing '1/4/05', but when I click in some of the
> records, the date expands to show '1/4/1905' in some records, and it shows
> as 'x/x/2005' in other records. They should all be 'x/x/2005'. How can I
> correct this database to have all the years change to 2005?
>
> Thanks.
>
> -Dennis
>
> --
> Dennis Kessler
> http://www.denniskessler.com/acupuncture

Lots of different ways, but essentially you want to do a find on dates
1/1/1905..12/31/1905 to get your found set of bad dates; and then
perform a replace, by calcuation:

date(month(thefield), day(thefield), 2005)

That will grab the month / day parts of the 'thefield' and recombine
them as a date in 2005.

-cheers,
Dave