Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
Try something like
=count({$<[In_Order Date]={">=$(=num(addmonths(today(),-1)))<=$(=num(today()))"}>} distinct InvoiceNo)