How can I query the fields which fieldtypes are date or float ?

[Former Member]

HI!

I can query the fields which fieldtypes are date or float,but the result is wrong when they are empty.

I can deal with the situation when the field is string, as followed

co.companyalias LIKE '" & IF(ISNULL (@companyalias),'%',@companyalias) & "%'" & "

Best regards!

csquare

[Former Member]

Hi csquare csquare,

can you use the function to cast the data type? - So that you get a string instead a date.

Hope that helps.

Best Regards,

Marcel