HI

The max fonction is returning large numbers when searching to find the
maximum in a DATE field

MAX (table::date) will return nomething like 63425030400 instead of a
date value "12/12/09"

I want to validate if an item is still under warranty for a customer,
but I can't get the MAX value of the related data...

what is wrong with the fonction or how can I use it to make it work ?!

Thank you

I forgot to add.. the related date table is a SQL database, so the
maximum search is outside FM, data display just fine, searching is
also fine.. only the MAX -MIN fonction that are not working...

Thanks

"Bizouman" <bizouman (AT) gmail (DOT) com> wrote

There's nothing wrong with the Max or Min functions. I'm not sure where
you're using it, but if you using it in a Calculation field (for example),
make sure the field is set to be a Date result, not a Number result.

Another possibility, since you are getting the dates via an external SQL
source, is that FileMaker my not be recognising them as actual dates. In
this case you would have to do some manipulation to get the data as real
dates first or write a custom "Max" function.

Helpfull Harry )

Bizouman <bizouman (AT) gmail (DOT) com> wrote:

The SQL field is probably DATETIME or SMALLDATETIME type. In FMP 10, you
can change the field type to date in your shadow table. If you're using
FMP 9 or if you're working with imported data rather than shadow tables,
see Helpful Harry's post.
--
http://clk.ch

On 21 nov, 03:52, c... (AT) tele2 (DOT) ch (Christoph Kaufmann) wrote:
THANK YOU !!! we learn something new every day... never notice that we
can change the data type from timestamp to time or date in FM10 !!, I
had find a work around, using a calculation field, but one day, 1
zillion fields for calculation to do a work around will slow down the
machine !!

JF