What is the difference between Today() and Now() in SSRS?

reporting-services ssrs-2012 ssrs-expression
krynil picture krynil · Dec 9, 2015 · Viewed 10k times · Source

Is there a difference between Today() and Now()?

When I searched online for date expressions I noticed that both are used quite frequently to retreive the same information. Which expression should I be using?

Today() and Now() in a report:

<code>Today()</code> and <code>Now()</code> in a report

Answer

Ian Preston picture Ian Preston · Dec 9, 2015

As your example shows, both return today's date, however Now() will also include the time when the expression was called. Today() will effectively be today at midnight.

Difference between System.DateTime.Now and System.DateTime.Today goes into this in much more depth, though in the .NET context, not specifically SSRS.

Which one should you use? Depends on what you want, as you can see they do two different things. Maybe if you don't care about a time component, use Today(), otherwise use Now().

Related questions

SSRS. How to hide blank/empty column via expression?

I need to hide column if all rows in column is empty (blank). In this case col3 should be hidden, because no values in column. col1 col2 col3 v1 v4 v2 v3 I'm using following expression on columns Hidden property: =…

Read More
How to get rid of blank pages in PDF exported from SSRS

I have a two-page SSRS report. When I exported it to PDF it was taking 4 pages due to its width, where the 2nd and 4th pages were displaying one of my fields from the table. I tried to set the …

Read More
SSRS 2008 R2 - SSRS 2012 - ReportViewer: Reports are blank in Safari and Chrome

I migrated our reporting services from version 2008 to another server version 2008 R2. In version 2008 the reports work fine on Safari. The new version 2008 R2 the reports do not show up at all. All I see is the parameter section and …

Read More