indexed calculation field dependent on date

[daniel z]

Hi

I've created an indexed calculation field which is dependant on

(among other things) a date field and the Today function.

However when the date changes, the calculation field does not

automatically update. I assume this is because Filemaker Help

says I have to first stop and restart the server each day

for the Today function to update.

Is there any way around this ?

Thank you

(and apologies if this is the wrong forum... this is my first post !)

[Lee Smith]

Hi daniel, and Welcome to the Forums.

That is how the Today Function works. Use the Status(CurrentDate) instead.

However, using the Status(CurrentDate) will kept the calculation field from indexing, so you face another challenge.

Why do you need this field to be index, is it a Key in a relationship?

Maybe there is another way to set this up if so.

Lee

BTW, please update your profile to reflect the Platform, operation system and version of FileMaker you are using. The link is just below your name in blue "profile".

[Westinghouse]

You could have a "today date" field that is updated each day by a script. Your calculation field could refer to that field.

[daniel z]

Thanks for the input!

The field is not a key but is used frequently (many times a day)

for searches. It needs to be searchable quickly. However I will

use Status(CurrentDate) and see what difference it makes to the

search speed.

Interestingly, today I discovered that even after stopping and restarting

the server, the field has not been updated. Is this because it has been

indexed ?

[daniel z]

You could have a "today date" field that is updated each day by a script. Your calculation field could refer to that field.

Thats both simple and clever ! I like it !

Why didn't I think of that?

Is there any way of getting a script to run every day automatically, though?