back end. 1  There are twenty-two men on it, thirteen at the front end, and nine at the back end. Rollo on the Rhine Jacob Abbott. 2  The third bomb fell into the back end of the shed, but I guessed it was not required. The Sequel George A. Taylor. 3  You could get behind the counter only by a swinging gate at the back end.
The GETDATE function produces the current date and time in SQL Server 2005 internal format for datetime values. GETDATE takes the null parameter ( ). Here is the result set. You can use GETDATE in designing a report to have the current date and time printed every time the report is produced. GETDATE is also useful for functions such as logging the time a transaction occurred on an account. You can use GETDATE anywhere to return the current system date. For example, you can use GETDATE as a default value for data entry, with a local variable, or comparing an order date to the current date.
Do it on your =NOW() formula, and it should stay fixed. I would try inserting the current date into a cell via a macro. The question then only is, when and how to trigger that. You could for example press a button and it would insert today's date (not as a formula) into a cell (one particular or the selected one). In VBA you can use Now(), Date() and Time(), depending on what you need exactly.