Good morning,
We are using Filemaker 6. We have a database that is shared
through Web Sharing and if the end users do not enter the date in the
web form, Filemaker will enter ther correct day, but the year is
showing up as 1907 not 2007. How can I change this?

In article <1178884074.308455.104720 (AT) h2g2000hsg (DOT) googlegroups.com>,
jerthebear <jerthebear (AT) gmail (DOT) com> wrote:

Make sure the intructions say to enter a four digit year ... OR create
a new Calculation field to automatically add 100 years if the
EnteredDate is before 1970 (or whatever year you choose).
ie.
ActualDate Calculation, Date Result
= If (Year(EnteredDate) < 1970,
Date(Month(EnteredDate),
Day(EnteredDate),
Year(EnteredDate) + 100
),
DateEntered
)




Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)