set expression

[#1]

REC_DAT <= monthend & GR_DAT = “ NULL” or > monthend

i need the set expression for the above logic

REC_DAT and GR_DAT are the fields that contains date(DD-MM-YYYY)

[its_anandrjs]

Can you explain your expression with and example of the data.

[#3]

Hi,

no its for all the months in the fiscal year it starts from mar 2013 to current month

[its_anandrjs]

You can try with

=Sum({<REC_DAT ={'<=$(=MonthEnd(Today()))'}, GR_DAT ={ '' } + {'>$(=MonthEnd(Today()))'}> INV_QTY}

[#5]

REC_DAT is where i get the stock to my place and i keep it in a warehouse and i calculate it for >monthend so i will check the total quantity that i got for the month and the GR_date is the thing that i have utilised the quantity so it should be greater than the date that i have received ...and if its null then the stock is still in the ware house so i have to calculate the total quantity that is present in the warehouse