Reporting Services Remove Time from DateTime in Expression

reporting-services expression ssrs-expression
Jeff picture Jeff · Sep 8, 2009 · Viewed 149.4k times · Source

I'm trying to populate an expression (default value of a parameter) with an explicit time. How do I remove the time from the the "now" function?

Answer

Michael Maddox picture Michael Maddox · Sep 8, 2009

Something like this:

=FormatDateTime(Now, DateFormat.ShortDate)

Where "Now" can be replaced by the name of the date/time field that you're trying to convert.)
For instance, 

=FormatDateTime(Fields!StartDate.Value, DateFormat.ShortDate)

Related questions

SSRS Expression for IF, THEN ELSE

I am creating a field from tables with our shoretel phone system and i am intergrating reports via SSRS and i need some assisstance with an expression. =if(Fields!ExitReason.Value 7, then if (Fields!ExitReason.Value 1, else if (Fields!ExitReason.…

Read More
Using 'like' in ssrs expressions

I'm trying to highlight a field when the value has the word 'deadline' in it. I'm trying to use the expression: =IIf(Fields!Notes.Value like "%deadline%","Yellow","Transparent") in the BackgroundColor property. It's not highlighting the field (not changing …

Read More
Count expression SSRS Report

Trying to count all rows in a column where column=Yes I have two columns in my report Accepted and rejected. I'm trying to count the rows where accepted=Yes and do the say thing for rejected. I've tried these: =…

Read More