I have a field in the SELECT statement that is a standard YYYY-MM-DD 00:00:00 format and I would like to convert that value to a simple YYYY format.  Then I would like to group by that value in the report.

 

What is the syntax for the conversion?

 

I have tried the following:

 

TO-DATE / TODATE

TOTEXT

 

Searching the web, i'm not finding what I need.

 

Thanks,

 

SRK

 

Thanks for the direction.

 

SRK