Creating a variable and parameter filter

[tjpren]

Hi All,

I'm finally getting round to customising my first report.

The standard "getting started" tutorial worked fine, and I manged to get a report to run - excellent!

I'm now trying to filter my report based on the date.

I'm using an MS SQL 2005 database with a timestamp field as mm/dd/yy hh:mm:ss.

I'd like to:

1. create a variable (called Date) to convert the timestamp field to mm/dd/yy

2: create a parameter to filter on the variable, Date

I can see how to create the Variable, but don't understand how to write an expression. From the expression builder I selected the field and the getdate operator as follows:

$F{tblDelivery_EndTime}.getDate()

This doesn't work.

Help please for the correct syntax to create a variable