Date Range (Help)

[Remi_BILLARS]

Hi all,

I need your help because I tried everything … and I spent hours there.

I need to sort the data according to a date period.

I have a DATA sheet, a FILTER sheet with 2 columns “Date Start” and “Date End”.

In Filter sheet I created a virtual column and I tried to put:

SELECT (DATA [_ROWNUMBER], [Date]> [_THISROW]. [Date Start], [Date] <[_THISROW]. [Date End]

THEN

SELECT (DATA [_ROWNUMBER], [Date]> (FILTER [Date Start], Date] <(FILTER [Date End]

The first only takes into account the “DATE START” BUT DO NOT TAKE INTO ACCOUNT THE “DATE END”.

Thank you for helping me. I really can’t do it.

thank you so much

[Steve]

If the intent is to sort the data for display in a view (e.g., a table view), the view itself should be configured with your sorting preferences:

[Remi_BILLARS]

Thank you but I really wish to have the exact formula, I am obliged to have a Filter with a start date and an end date to search for precise information

Thanks you again

[hru]

If:

Remi_BILLARS:

SELECT (DATA [_ROWNUMBER], [Date]> [_THISROW]. [Date Start], [Date] <[_THISROW]. [Date End]

Change to:

SELECT(DATA[_ROWNUMBER], AND([Date]> [_THISROW].[Date Start], [Date]<[_THISROW].[Date End]))

[Remi_BILLARS]

The formula is valid BUT the result is that the first date is taken into account in the sorting (Date Start) BUT the second (Date End) is not taken into account …
Watch an example from my screenshot.

I put in Date End 12/31/2022 but look I have a result in 2023 …Someone else ?

Thanks again

Rémi.

[hru]

Hmmm, how about:

FILTER("DATA", AND([Date]> [_THISROW].[Date Start], [Date]<[_THISROW].[Date End]))

[Remi_BILLARS]

thanks it works! I was wrong, I had not seen the “AND” in the formula.

the right formula is therefore:

SELECT (DATA [_ROWNUMBER], AND ([Date]> [THISROW]. [Date Start], [Date] <[ THISROW]. [Date End]))

Thanks to Heru you are my hero, and everyone who participated, I hope it will help other beginners like me.

Thanks to the community …