Re: YTD Last Year again

On Fri, 2 Sep 2005 14:59:01 -0000, Benedikt Fridbjornsson wrote:

>Hi there, I'd like to ask you for help with following:
>
>I am trying to select YTD for last year in my sales table. Our accounting
>year is from 1st of July to 30 June.
>
>
>
>select *
>from Salestable
>Where Postingdate > "1st of July 2004" and
>Postingdate < "today last year"

Hi Benedikt,

The easiest way to get this done is to use a calendar table.

http://www.aspfaq.com/show.asp?id=2519

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)
.