Set expression

[#1]

Fields:

REC_DAT             Received Date

WERKS                  Plant

MATNR                Material Number

INV_QTY              Invoice Quantity – 3PL qty

PCN_DAT            PCN date

GR_DAT               GR Date

Logic

For 3PL stock as on 30.04.2014

REC_DAT <= monthend & GR_DAT = “ ” or > monthend this is the logic that i should calculate for all the monthend value to get the 3pl stock

({<REC_DAT= {"<=$(=MonthEnd(Today()))"}, [GR Date]= {">$(=MonthEnd(Today()))", ''}>}

I tried the above expression but it doesnt work

[tresB]

In such queries attach a sample qvw to get faster solution.

[Gysbert_Wassenaar]

Try something like sum({<REC_DAT= {"<=$(=MonthEnd(Today()))"}, [GR Date]= {">$(=MonthEnd(Today()))"'}>} INV_QTY).

Note, you will have to make sure the date formats of REC_DAT and GR Date match the default date format of your document.

[#4]

thats not working and i have tried it before
and date formats is same for all

[ali_hijazi]

what is the format of REC_DAT and GR_DAT are they numeric or readable dates?

MonthEnd(Today()) will return a value that is formatted and not numeric

[#6]

31-04-2014(DD-MM-YYYY) this is the format for all the date fields in the application

[Gysbert_Wassenaar]

Make sure your date fields actually contain data values and not string values that only look like dates.

[ali_hijazi]

if your date fields are numeric use $(=num(DayStart(MonthEnd(Today()))))

[ali_hijazi]

I would update these values by using num(DayStart(Rec_Dat)) as Rec_Dat in the script

then in the expression us  $(=num(DayStart(MonthEnd(Today()))))

date values that are formatted are hideous

[#10]

this is the sample application have a look at it once