>Hello,
>
>I have a view pulling data from MSSQL 2000 table. I'm using the filter statement to limit my data. I filter is on a Datetime field with the field property set to date. The filter statement is:
>
>err_datetime = ?lddate
>
>lddate = date()
>requery('viewe')
>
>This returns all records. Any suggestions?
>
>
>Regards,
>
>Steve
In addition to Hilmars advise you can use datepart functionm to compare year, month and day of your datetime field
Venelina Jordanova
Outsourcing IT Services Ltd.