The NOW function does not update automatically when you open a spreadsheet or database document. You must force the NOW function to update using the Calculate Now command in spreadsheets or for databases, by choosing Define Fields from the Layout menu and pressing the Done button.
This is the way the NOW function was designed to work.