Hello and happy Friday!
I have a several reports that accept date range parameters. These are not the textboxes that show you a calendar when you click the box, but just 2 simple textboxes (Startdate and Enddate). Is there a way for me to force the user to type in a date range in 'mm/dd/yyyy' format? Also is there a way where I can at least have 'mm/dd/yyyy' as a default in the textboxes so they know what format to use or prehaps a default date range for the current day dynamically hardcoded into the date range text boxes?
Here is the code that I have in the dataset properties. Thank you all in advance.
Select * from v_SQL_VIEW
WHERE Dates Between @Startdate and @Enddate
order by 1