Date Calculation Help

[Moosh]

Hi there,

Is there a way that FM tracks the current date always, without having to paste it into a field?

I am building a real estate database and want to specify the end date of a lease, and then do this

end date (in future) - current date = remaining days left on the lease

Thank you!

Moosh

[Lee Smith]

Look in the Get Functions.

It is called Get (CurrentDate).

Make a field, (Calculation, result as Date ) =

Get (CurrentDate)

Choose the option for the field, and make it Unstored by clicking on the Do Not Store Calculation button.

HTH

Lee

[Moosh]

Thank you so much!!!

This totally does it.

Cheers,

Moosh