Parameter for Date Range

[AlreadyLost]

I think my report is not pulling in the right date from the Parameter..

I have a start date and an end date in my parameter.In selection formula -> record, I have this formula:

{TB_INVOICE_LINE_ITEM.APPLIED_DATE} in {?start date} to {?end date}

Is there something wrong with this formula? I want it to pull everything between the start date and end date (8/1/2004) to (8/30/2005). The report doesn't seems to be doing it.

 

[paulmarr]

Try:

{TB_INVOICE_LINE_ITEM.APPLIED_DATE} >= {?start date} and
{TB_INVOICE_LINE_ITEM.APPLIED_DATE} <= {?end date}

Also check that the date field and your parameter are the same date format. ie dd/mm/yyyy

I hope this helps

Cheers
paulmarr