FM 6 to FM 7growing pains - Dates

[John Chamberlain]

Still trying to adjust - whatever happened to the Status functions? Can't get my mind around date calculations - what I need is to compare a due date to the current date, in order to identify delinquencies. In FM 6 there was a Status(Current Date) function that could be used for testing - but what is it's eqivalent in FM 7?

[LaRetta]

Get ( CurrentDate ) - DueDate > 30

or

Get ( CurrentDate ) - 30 > DueDate

These calculations must be unstored since they use Get ( CurrentDate ) and they produce a boolean 1 meaning the record is more than 30 days past due. You can use it also like to produce text, such as:

Case ( Get ( CurrentDate ) - DueDate > 30 ; "Overdue" )

[John Chamberlain]

Thanks LaRetta - guess I didn't get the Get function.

BTW, can anyone recommend the best book for us poor souls who are just transitioning to the new world of FMP 7-10?

[Lee Smith]

whatever happened to the Status functions?

FileMaker Changed the name to Get