Thursday 4 December 2014

SSRS Report: Formatting Date parameter, UK Format, Show Calendar

In order to compare the input Date and Date stored in the database, 
convert both of the Date to specific format, then compare and it will work without giving conversion error. For example, 

WHERE CONVERT(DateTime,styr.STYR_Enrolled_On,103) <= CONVERT(DateTime,@RefDate,103)

  1. Make the Parameter data type to Date/Time
  2. Default value expression= Today()
  3. Change the Report Language to User language
  4. Display date in UK format, expression: format(parameters!RefDate.Value,"dd/MM/yyyy")










0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home