YTD for previous year

[mrscoe]

I am fairly new to access, so please be patient with me : )

I am trying to create an expression to pull data from 2011 to present date. I need the data for 2011 to only reflect 1/1/11 through 10/7/11 (today's date in 2011). I need the same for 2012 and 2013.

I don't want to have to enter dates each time I run this, therefore, a formula would be preferred rather than hard numbers.

Thanks in advance for any help!!!

Jessica

 

[pbaldy]

You can use the DateSerial() function, along with the Date(), Month() and Day() functions, hard-coding the desired year.