Set analysis

[#1]

Hi!

I use

count({$<[In_Order Date]={'=Year([In_Order Date])=2012'}>} distinct InvoiceNo)

and [In_Order Date] is YYYY-MM-DD hh:mm:ss

I would like to to set expression but with [In_Order Date] between 2011-11-26 and 2012-11-26.

How do I do it?

/Julia

[Gysbert_Wassenaar]

try:

=count({< [In_Order Date]={'>=2011-11-26<=2012-11-26'} > } distinct InvoiceNo)

if that doesn't work try

=count({< [In_Order Date]={">=$(=date#('2011-11-26 00:00:00','YYYY-MM-DD hh:mm:ss'))<=$(=date#('2012-11-26 00:00:00','YYYY-MM-DD hh:mm:ss'))"} distinct InvoiceNo)

[swuehl]

Try something like

=count({$<[In_Order Date]={">=$(=num(addmonths(today(),-1)))<=$(=num(today()))"}>} distinct InvoiceNo)