YTD Info

[RLA]

Hi,
Can someone please help me with a function to find year-to date info? I've been using a hard-coded date w/ Date(), i.e. in a query or report saying 'return info from Between #1/1/03# And Date()'. However, I would like to avoid hard coding if possible. I think it is reasonably simple code, but it's taking me forever to figure it out. Please help, thanks very much!

 

[CosmoKramer]

Try something like this:

.....Between "1/1/" & Format(Date(),"yy") And Date()

It hardcodes the 1/1 date as the beginning of the year, and appends the current year to that 1/1 date.....