I created a custom WA DE report in Desktop Client and I have some doubts about report filters.
I used the CA WA Simple Listing with Date Filter Template and I´m using this query in my Data Set.
select ESP_GENERIC_JOB.JOB_NAME,ESP_GENERIC_JOB.JOB_QUALIFIER,
ESP_GENERIC_JOB.START_DATE_TIME,
ESP_GENERIC_JOB.END_DATE_TIME,ESP_GENERIC_JOB.STATE,
ESP_APPLICATION.APPL_NAME
from ESP_GENERIC_JOB,ESP_APPLICATION
where ESP_GENERIC_JOB.APPL_ID=ESP_APPLICATION.APPL_ID
and ESP_GENERIC_JOB.START_DATE_TIME between ? and ?
I used the date filters associated witn ESP_GENERIC_JOB.START_DATE_TIME but I can only use the filter in the Date format, not DateTime.
I want to know how to configure it to use DateTime format and I want that when I run the report (or preview it) the date filter will be in calendar style, not forcing me to fill the date mannually