datetime parameter in BI report
I have a BI report in Oracle ERP where I want to select data since the last time the report was run, so to do that I have created a last update date Date parameter. It works for dates, but not date times. Is there a way to get it to work with a datetime parameter? The user would like to be able to run the report multiple times per day and only get the items that changed since the last run, which requires datetime and not just date.
I tried setting the date format string to yyyy-MM-dd'T'HH:mm:ss.SSS'Z' but although it accepts the format string, when I run the report it tells me the parameter is missing.