>>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)

Well, as long as it's concise - and yours was. Guess I'm just lazy today. Thanks!