Today Function

[DMGoldie]

I have a script from a FileMaker 4.1 DB that finds records that were entered in the last 24 hours. I used a Paste Result (Today - 1). I believe "Today" doesn't exist in FM 7.0 - does anyone have an idea how to re-created this script in FM 7?

Thanks,

David

[stanley]

David:

In FMP 7 you would use Get(CurrentDate), the same way as in earlier versions you would use Status(CurrentDate). The Today function never really worked correctly anyway, and should be replaced in older versions of FMP with Status(CurrentDate).

-Stanley

[-Queue-]

If I recall correctly, Today actually did work fine when used in script steps in previous versions. It is only in calculation fields where Today would not update unless the file was closed and opened every day.

[Vaughan]

Today assumed that the file would be regularly closed and opened again -- the function only recalculates when the file is opened. Files that are left open for long periods -- like on a FM Host -- will prevent Today from recalculating.

[DMGoldie]

Stanley,

Thanks for your reply. I spaced on Get(CurrentDate). It's hard to break old habits...

Thanks Again,

David