How to format date

[taree]

I would like only to match the year:

{BIDLET.DATELET} = CDate({?Letting Year})

in this case the letting year is 2008,2009,2010 so,

I would like to pass the year 2008 as a parmater

{BIDLET.DATELET} = 2008

thank you

 

[lbass]

Set up the parameter as a number parameter. If your field is not a number for year, but a date, then you can use:

year({BIDLET.DATELET}) = {?Letting Year}

Or better yet, convert the field to a year field in a SQL expression {%year}:

{fn year(BIDLET.DATELET)}

...and use a record selection formula of

{%year} = {?Letting Year}

-LB