Is there a way to Lock down a date formula?

T

Tiffany C.

I am using some Now() functions to show the date on current month reports,
but when those reports are opened in succeeding months the dates then change
to the new current month. Is there a way to keep the data automated but at
month end lock the field? As opposed to copying and saving the date as a
value.

Thanks for any help on this.
Tiffany
 
M

Marcelo

Hi Tiffany,

you could use

=if(today()>date(2006,08,31),date(2006,08,31),today())

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Tiffany C." escreveu:
 
Top