Hi,
Is it possible to set a datetime parameter to always use a particular time?
I have two parameters used in a SQL query which are datetime. It defaults to the current system time of the user selecting the datetime which can cause data to be missing from the report.
I would like {?Start} to always be 00:00:00 and {?End} to always be 23:59:59. I have tried using a 'Date' parameter but it causes errors with my SQL.
Thank you
Is it possible to set a datetime parameter to always use a particular time?
I have two parameters used in a SQL query which are datetime. It defaults to the current system time of the user selecting the datetime which can cause data to be missing from the report.
I would like {?Start} to always be 00:00:00 and {?End} to always be 23:59:59. I have tried using a 'Date' parameter but it causes errors with my SQL.
Thank you