Show sales between 2 dates

Lili123 — Wed, 23 Nov 2022 17:57:30 GMT

Hi,

I need to show sales that between 2 dates.

First date is the 1.1 of the specific year that is selected

Last date is the last day of the previous month that was selected

Example - I selected day 1 -10, month May, Year 2022.

So in this case I want see sales for the period : 1.1.2022 - 30.4.2022. The issue that I want to see sales that are out of range that is selected (1.05.22 - 10.05.22).

=Sum({<Date=,Day=,Month=,[Date] = {">=$(=Date(YEARSTART(vSelectedDate)))<=$(=Date(MONTHEND(AddMonths(Max([Date), -1))))"}>} [SALES])

The result is the same for every month, I think because this on (Month=), but if I don't put it the result is not correct too, since months that I need are excluded.

I don't really know if it is possible.

I try it, but it is not working.

Please advise.

Re: Show sales between 2 dates

Dalton_Ruer — Mon, 28 Nov 2022 14:43:56 GMT

So in this case I want see sales for the period : 1.1.2022 - 30.4.2022. --- Makes perfect sense and is easily doable.

The issue that I want to see sales that are out of range that is selected (1.05.22 - 10.05.22). --- Not sure I understand where these dates came from. Does this mean you want to use a filter to choose the Start Date and a filter to choose the End Date and then get the sales for that range?

topic Re: Show sales between 2 dates in App Development

Show sales between 2 dates

Re: Show sales between 2 dates