i need to use monthend function and compare two field dates

[#1]

Hi,

REC_DAT <= 30.04.2014 & GR_DAT = “ ” or > 30.04.2014

in the place of date i need to use monthend function to get all the sum of the inventory that are present on the final day of the month

[jonathandienst]

Hi

Use

     REC_DAT <= Date(MonthEnd(SomeDateField), 'DD.MM.YYYY')

HTH

Jonathan

[#3]

Hi Jonathan

may be the data that i have provided is not enough

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 <= 30.04.2014 & GR_DAT = “ ” or > 30.04.2014

For 3PL stock as on 31.05.2014

REC_DAT <= 31.05.2014 & GR_DAT = “ ” or > 31.05.2014

i need the sum of invoice quantity for each and every month