Your technology certification is waiting. Enroll in Cloud Class ®
select NULL as 'Value'
, 'All dates' as 'Label
Select distinct yourDateField as 'Value'
, CONVERT(nvarchar(12), yourDateField, 103) as 'Label'
Where "apply your selection criteria here"
Open in new window
IF @date is null
Select your report records without a date filter, or to include all desired dates
else if @date is not null
Select your report records with the date parameter in the where clause
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Please enter a first name
Please enter a last name
Must be at least 4 characters long.
Join and Comment
Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.