software

I have a report that I use today() in part of the formula. Problem is if some
looks at yesterdays report is isn't correct becuse now it using today's date
and not yesterday's when I actually ran the report.
Is there a simular formula or something that works like today() but would
use the day it was created instead of always using the current day.

Hope this makes sense.

Thanks

instead of entering =today(), press ctrl/; which will put today's date in as
a constant.

quot;Str8quot; gt; wrote in message
news
gt; I have a report that I use today() in part of the formula. Problem is if
some
gt; looks at yesterdays report is isn't correct becuse now it using today's
date
gt; and not yesterday's when I actually ran the report.
gt; Is there a simular formula or something that works like today() but would
gt; use the day it was created instead of always using the current day.
gt;
gt; Hope this makes sense.
gt;
gt; Thanks