SSRS: Datetime 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”)

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s