good afternoon,

In my database I store a future date. (will obviously become a past
date at some point)

I need to know how many days there are between now, and the date in
question.

In VB I use datediff("d",now(),datefieldname)

How can I do this in FMP8.5?

Thanks

Tim

Hi,
In FileMaker, dates are stored as a number days after a given date (1st day
is 01/01/0001), and time as a number of seconds.
So your formula can be simply :
DaysLeft = Set Field [ Table1:aysFelt; Table1::FutureDate - Get (
CurrentDate )]
Remi-Noel

<Citizen10Bears (AT) gmail (DOT) com> a écrit dans le message de news:
1163513863.034797.150090 (AT) h54g20...oglegroups.com...

Sorry, correction :

Hi,
In FileMaker, dates are stored as a number days after a given date (1st day
is 01/01/0001), and time as a number of seconds.
So your formula can be simply :
Set Field [ Table1:aysLeft; Table1::FutureDate - Get (
CurrentDate )]
Remi-Noel

<Citizen10Bears (AT) gmail (DOT) com> a écrit dans le message de news:
1163513863.034797.150090 (AT) h54g20...oglegroups.com...

"DaysFelt" - an excellent typo!

thanks for your help

Tim

In article <1163518497.759476.311620 (AT) m7g2000cwm (DOT) googlegroups.com>,
Citizen10Bears (AT) gmail (DOT) com wrote:

As Remi-Noel says, dates within FileMaker are simply stored as "days",
so you can easily subtract one date from another to get how many days
are between the two.

Similarly, times within FileMaker are stored as seconds, so you can
simply subtract one time from another to find out how many seconds are
between them. (Of course it gets a little trickier if the times are on
two different dates.)

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