Need to pull odd or even years from a datetime field

[Juliep]

I need to create a report that pulls either all odd years and one for all even years from a datetime field (ie 3/1/1999 12:30pm). I also need it to exclude the current year. Does anyone have any suggestions.
Thanks
Julie

 

[ScottGS]

This should do it:

// Even Years
Year({DateFieldToCheck}) < Year(CurrentDateTime) and ((Year({DateFieldToCheck}) mod 2) = 0)

// Odd Years
Year({DateFieldToCheck}) < Year(CurrentDateTime) and ((Year({DateFieldToCheck}) mod 2) = 1)