BI Publisher set the default time to midnight
i am trying to set the default time in the data model for a BI Publisher report to midnight.
i am using {$sysdate()$} as the value in the default value column. this sets the time to the current time or time when the report/data model is opened.
i want the report to show the midnight of the current day every time a user opens a report.
I am using mm-dd-yyyy HH:mi:ss as the date format. if i remove HH:mi:ss from the date format, the time is set to midnight but the problem with that approach is that the date widget doesn't show the time picker. so the user can't select the time, they can only select the date.