Show off. <bg> Not quite., though. It doesn't work if the date is January 1st of the year.


>I believe this will return the date you require WITHOUT the year function or string manipulations.
>

>? GOMONTH(DATE(),-MONTH(DATE())+1) - DAY(DATE()-1)
>

>
>Glenn
>
>>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?