NOW (Report Builder)

Returns the current date and time.

Syntax

NOW( )

Example

Formula	Result
NOW( )	Returns the time that the report ran in the following format: 5/21/2010 12:06:32 PM.
QUARTER(NOW( ))	Returns the quarter (1-4) that today's date falls into, for example, 2.

See Also

Concepts

Working with Formulas (Report Builder)
Using Functions (Report Builder)
Date and Time Functions (Report Builder)
Report Builder How-to Topics
Working with Literals in Formulas and Filters (Report Builder)
Formatting Numerical Data (Report Builder)

Help and Information

Getting SQL Server 2005 Assistance