>Given the current date I want to get the first day of the year.
>
>Parameter: DATE()
>Wanted: {01/01/2004}
>
>Is there a simple way to do this without using the YEAR function and string manipulations?
You're going to have to do one or the other. <g>
DATE(YEAR(DATE()),1,1)