Date question

[#1]

Hello, i need your help!

my task is to report the open orders for the future and the past,

for example

today 02.09.2014

i only want to select for this example like year '2014'  and  month '08'

1. I want to report every open order > 30.11.2014

2. I want to reprt every openorder < 01.08.2014

Thanx for your help...

[Anonymous]

assuming you have a field open orders and you displayed it ina loistbox

define search in the listbox and you canenter

"<01.10.2014' as well as ">30.11.2014"

that what you want?

[#3]

No, i have to report the € value of the open orders for dimension: customer in a pivot table

and in one column i have to report the € value of the open orders € value <01.10.2014 and

in the second column i have to report the € value of the open orders > 30.11.2014

for the example to select year '2014'  and  month '08'

[#4]

Hi,

It should be possible with set analysis, like

Sum({<OrderDate={"=OrderDate<MakeDate(2014,10,1)"}>} OrderValue)

And so on for other dates.

Hope this helps