RowFilter date expression

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there an easy way to filter a datetime column on the year. The following
does not work:

YEAR(BeginDT) = 2006

Also does any one know if there is a list of valid expressions for the
rowFilter?

Thanks for your help.
 
YEAR function returns string, so I would try YEAR(BeginDT) = '2006' - It's
in SQL Server. In other environment use appropriate syntax.

Esha
 
Back
Top