Calc: Fix the variable =TODAY()

[Mats]

Hi,

I need to get the function =TODAY() to stay on the date when the document was saved/created.

I have created a invoice template for my business. The template has a macro that saves the invoice in a predefined folder and uses the invoice ref no as document name.

But I have not found out how I should solve the “Invoice date” =TODAY(), if I open the the invoice later the date will be changed to the current date. Can someone give me a pointer to how to solve this changing invoice date to a fixed/permanent date?

[mahfiaz]

Go to that field and press Ctrl + ;

This will insert current fixed date/time to that field.