Parameter Date - Exclude Time

BIRTigo

Hi,

In BIRT 2.1. If I'm using 2 parameter Dates for 2 different charts one uses the Date and Time and the other chart only needs the Date, what format can i use so i can get just the date for the chart.

In the second chart I need to count per severity per day from Start Date and End Date Parameters so i don't need the time
Query:

select count(*) as Count,
severity as sev,
date(recievedDate) as RcvdDate
from Table
group by severity, date(recievedDate)

Sample Parameter input:
SDate: 07/14/2008 01:30:00 AM
EDate: 07/14/2008 12:10:00 PM


Count |severity | RcvdDate
======================
1 | Error | 7/14/2008 12:00 AM
1 | Error | 7/14/2008 12:00 AM
1 | Error | 7/14/2008 12:00 AM
1 | Error | 7/14/2008 12:00 AM
1 | Error | 7/14/2008 12:00 AM
1 | Error | 7/14/2008 12:00 AM
1 | Error | 7/14/2008 12:00 AM
1 | Error | 7/14/2008 12:00 AM
1 | Error | 7/15/2008 12:00 AM
1 | Notifications | 7/14/2008 12:00 AM
1 | Notifications | 7/14/2008 12:00 AM

The problem is that when I want to filter between SDate and EDate nothing is shown because of the time so i tried using
Betwwen DateTimeSpan.addDate(params["SDate"]) and DateTimeSpan.addDate(params["EDate"]) but it only converts the dates as
07/14/2008 01:00:00 AM and 07/14/2008 12:00:00 PM which still doesn't match the time so it still gives me wrong data...

Is there a way where I can get just the date of these parameters and disregards the time?

Please help.

Virgil Dodson

Hi BIRTigo,

BIRT report parameters can be Date, DateTime, or Time format. Have you tried selecting Date for the parameter format?