Roland,
I don't have a solution for remote views since I don't use them. In case you could use SQL passthrough, the following line should work:
SQLEXEC(lnSql, "SELECT whatever FROM MyTable WHERE DATEDIFF(day, BirthDate, getdate()) = 0")
As Vlad mentioned, you need to use functions supported by SQL Server (T-SQL) when using SPT.
This is different with remote views. I thought one of the advanteges of remote views was that you can define a view that works with different backends. Therefore I suspect above syntax won't work for RVs. Maybe an expert on remote views can chime in?
>Hi,
>
>I am trying to create a filtered remote view using the view designer.
>
>FILTER by:
>
>dbf.birthdate (This is a SQL DATETIME field) = Today's date
>
>Heres what I would like to use.
>
>TTOD(dbf.birthdate) = DATE(); but that does not seem to work.
>
>I am trying to select records that the birthdate((DATETIME)only the date part) is equal to today's date. I don't know how to express the above to get the view designer to accept the required filter.
>
>Could someone please explain the proper usage to accomplish the above filtering.
>
>Thanks in advance!
>Roland
Daniel