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)