>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
I don't know why all records are retrieved, but I would start doing two changes:
1) Change the date value to a datetime value. See dtot().
2) Use two parameters, as a range: err_datetime between ?ltTime1 and ?ltTime2.
HTH, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)