CODEWITHSUNDEEP
reporting-services
shortwalk
shortwalk

Reputation: 1

SSRS DateDiff having errors due to syntax

I tried a few ways of doing this but keeps erroring out. Have to convert a Crystal report to SSRS. Suggestions?

Crystal

DateDiff ("d",{CRSS_INSP_DET.NEXT_INSP_DTE},CurrentDate())

SSRS - both of these do not run

DateDiff("day", Fields!INSP_DTE.Value), Today())
DateDiff("day", Fields!INSP_DTE.Value), Now())

It says this

The Value expression for the textrun 'WRK_AAR7.Paragraphs[0].TextRuns[0]' contains an error: [BC30516] Overload resolution failed because no accessible 'DateDiff' accepts this number of arguments.

Upvotes: 0

Views: 115

Answers (1)

Chris Albert
Chris Albert

Reputation: 2507

You have an extra ) in your expression.

DateDiff("day", Fields!INSP_DTE.Value, Today())
DateDiff("day", Fields!INSP_DTE.Value, Now())

Upvotes: 0

Related Questions