I feel rather lame for asking a question that would seem to have an easy answer, but I have'nt been able to locate any information on how to implement a SQL statement that retrieves records based upon the year of a field date.

Here is the T-SQL that I want to implement:

 select distinct year(EffectiveDate) from tblRateIndices
where year(EffectiveDate) = 2005

Any suggestions, samples, etc.

Thanks.

Would this just return 2005? What type of database are you using? Thanks

Please see: http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=3829 for an idea how to implement IExpression for an expression which will emit YEAR(field) Then, create a dynamic list, and add an instance of your IExpression implementation to the ExpressionToUse property of the field in resultsetFields.

Otis wrote:

Please see: http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=3829 for an idea how to implement IExpression for an expression which will emit YEAR(field) Then, create a dynamic list, and add an instance of your IExpression implementation to the ExpressionToUse property of the field in resultsetFields.

Thanks...that really helps.