I have a database which I want to filter by the datetime column. I am trying to achieve this by using the date range component in the vision client. I am currently using the “Start Date” property and “End Date” property to set my desired range. But the start and date comes in a different format then what sql desires. Is there another way to get the required data?
Use a named query with Date Value parameters. Then you don’t have string conversions.