FilterExpression by year of date 1

[dstrange]

Hello All,

In code I'm trying to use a filterexpression on a datetime field only by the year.

ex.
datasource.FilterExpression = "year[postDate] = '2007'"

In sql I can use:
select * from tblTable where year(datefield) = '2007'
and it works.
Any ideas? Thanks in advance.

 

[jmeckley]

var january_1st = new DateTime(year, 1, 1);
var december_31st = new DateTime(year, 12, 31);
var filter = string.Format("year >= {0} and year <= {1}", january_1st, december_31st);
datasource.FilterExpression = filter;

Jason Meckley
Programmer
Specialty Bakers, Inc.

 

[dstrange]

Can I use the function year to extract the year on a date in the filterexpression?

I get the error below when I try this filterexpression:
datasource.FilterExpression = "year[datefield] = '2007'"

"The expression contains undefined function call year(). "

 

[jmeckley]

the exception is telling you what the problem is. year() is undefined. I would assume that means; no, I cannot use functions within the expression.

again, why not just look for dates between janauary 1st and december 31st?

Jason Meckley
Programmer
Specialty Bakers, Inc.

 

[dstrange]

I'm trying but still having no luck....

Dim january_1st As New DateTime(rsNews.Item("yearDate"), 1, 1)
Dim december_31st As New DateTime(rsNews.Item("yearDate"), 12, 31)

Dim filterstr As String = String.Format("postdate >= #{0}# and postdate <= #{1}#", january_1st.ToString, december_31st.ToString)

sLatestNews.FilterExpression = filterstr

String was not recognized as a valid DateTime.

 

[jmeckley]

Dim filterstr As String = String.Format("[postdate] >= #{0}# and [postdate] <= #{1}#", january_1st, december_31st)

or

Dim filterstr As String = String.Format("[postdate] >= #01/01/{0}# and [postdate] <= #12/31/{0}#", year)

Jason Meckley
Programmer
Specialty Bakers, Inc.