How to select rows with due date between selected period

[former_member254358]

Hi Experts,

I'm making a query on 0FIAR_C03 infosite

The requirement that they ask me is that when we have 0FISCPER and Posting Date in lines we could know the amount with 'Due date for net payment' (0NETDUEDATE) less than selected period.

For example, if we select the 0FISCPER 'FEB 2017', 'MAR 2017' and 'APR 2017' then the query should show item with 'Due Date' less than 30.04.2017.

Can anybody help me?

Thanks in advance.

Regards.

[former_member186445 · Accepted solution]

search the world wide web with 'bex query bucket'

[former_member231709]

0FISCPER has attribute 0DATETO. You can create a variable with type "replacement path" and fill it from your variable on 0fiscper.

[former_member254358]

Thanks for your help, I tink this is what I was looking for.

But In my case one of the dates has to be the last day of the selected period.

In my previous example,... the selected period was 'Feb 2017' - 'Apr 2017', how can I know which is the last day of 'Apr 2017' period?

The subtract between that date and the Due Date are the days I need.

Regards.