Date Format in VBA

[maabbot]

Hi

I have a function that determines a date.

From this date I want to adjust it to be the 1/1 of the year of that date.

using the Year(date) expression returns as year. But if I write a date as

#1/1/Year(date)# I get an error

Can anyone help....

 

[DonkeyOte]

format(...,"dateformat here")