Current date field

[mac_g4]

Can anyone tell me how to make a date field show the current date in every record. The use for this is to show the number of days that have passed since an invoice was issued by using a calculation field to show "Current date - Invoice date". Thanks.

[mz123]

You can make a calculation field:

Get(CurrentDate)

That should do it

Martha

[Lee Smith]

Be sure to Unstore the calculation.

Lee

[mac_g4]

Thanks Martha, that did the trick. Lee, how do you Unstore the calculation. Thanks. mac_g4.

[Lee Smith]

Define Fields >> Storage Options >> Select the "Do not store calculated results -- recalculate when needed.

HTH

Lee

[mac_g4]

Thanks Lee. Got there in the end.

mac_g4