Re: YTD Last Year again

Hi Hugo

I have created the Calendar table with the FY column. How can I use your
Calendar table to select what I need from my salestable.

select *
from Salestable
Where Postingdate > "1st of July 2004" and
Postingdate < "today last year"


"Hugo Kornelis" <hugo@xxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:p0dhh15uk4v5l94t10gkr7063d0ae39kop@xxxxxxxxxx
> 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)


.