Automatic Date Update

[Greg O'Connor]

Greetings.

I cannot find a way how FMP will automatically udates a date at midnight. I guess the Get(CurrentDate) only sets the date when a new record is generated.

If anybody knows a way, I would appreciate to learn about it.

Many thanks

Greg

[Lee Smith]

If you don't Store the Get (CurrentDate) calculation, it will change at midnight.

Define Fields >> Select Calcuation Field >> Storage Options >> Do not store calculation results

[Greg O'Connor]

Thank you very much Lee, sometimes the solution is so easy that I am almost blushing...

Thanks

Greg