Single Datefield (periode/date range) for start and end date

mwittmann — Wed, 25 Nov 2020 16:16:04 GMT

Hello experts,

i'm struggeling with the following for a long time. Herhaps anyone can help me. This would be great.

This is my table:

What i want to see is the average development of "value" by time. So i need a single datefield as a range depending on start and end.

By filtering a year or month of the periode, all value with

periode<=start and periode >=end

should be shown...

I think a third datefield as a daterange and a Set function which only shows the values with "start" and "end" within the timerange.

Thank you really much. I appreciate any advice.

Marcel.

Re: Single Datefield (periode/date range) for start and end date

sunny_talwar — Mon, 05 Feb 2018 16:40:52 GMT

May be you need IntervalMatch to a calendar table

mwittmann — Tue, 06 Feb 2018 09:02:43 GMT

Thank you