part of date question

[swarv]

Hi all,

I have the following code:

If Format(usersenddate, "YY/MM/DD") >= Format("1/1/*", "YY/MM/DD") And Format(usersenddate, "YY/MM/DD") < Format("1/4/*", "YY/MM/DD") Then

Where the code says 1/1/* I want the * to be the current year. i.e. 2009 then 2010 etc...

Can this be done?

Thanks

Martin

 

[boblarson]

Of course:


If Format(usersenddate, "YY/MM/DD") >= Format(DateSerial(Year(),1,1), "YY/MM/DD") And Format(usersenddate, "YY/MM/DD") < Format(DateSerial(Year(),4,1), "YY/MM/DD") Then

 

[swarv]

excellent thanks