Error with current date in record selection

[Former Member]

I am trying to use in the record selection formula. A date field is equal to current date. I keep getting an error saying character string failed in conversion to a numeric. I have no problems using a datetime field = to current date. but can not use a date field.

database is teradata and I am trying to push all of it onto the database.

[former_member11696]

There is an issue with this type of field in CR 2008. Install SP3 when its available

[Former Member]

did you try using datetime field=currentdatetime?

Regards,

Raghavendra

[Former Member]

Yes and it works but all filtering for that seems to be on the report level then. I do not see it in the sql query.

[Former Member]

Then you need to use add command and add the query like this

select * from table where datetimefield=getdate()

getdate() is the function in SQL server to get the currentdate. But I don't know what function that you have in teradata.

Regards,

Raghavendra

[Former Member]

This worked in CE10. And after migrating to 2008 it does not.