Answered

How to filter items depends on date range?

(0) Share

Report

Posted on by TomasG

255

Hi,

I would like to ask for help. I have SP list which contains two datetime columns (start_day, end_day).

And I need filter all items which are in date range. Date range is set to -2days from Now() and +10days from Now()

For example:

Item ID	start_day	end_day	result
1	15.12.2022	20.12.2022	not shown (wrong)
2	19.12.2022	21.12.2022	shown (correct)
3	15.12.2022	23.12.2022	not shown (wrong)

1 and 3 ID could be shown.

'Datum nakládky' = start_day

My filter expression is:
Filter(
'Evidence přepravy_1';//zdroj udajov filtru
'Datum nakládky' >=(DateAdd(
Now();
-2;
Days
)) And 'Datum nakládky' <= (DateAdd(
Now();
10;
Days
));

So I need to shown all items in date range. Can anybody give me advice? Thanks.

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

v-bofeng-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @TomasG ,

Please try:

Filter( 'Evidence přepravy_1';//zdroj udajov filtru Date(Last(Split('Datum nakládky';".")).Result;Last(FirstN(Split('Datum nakládky';"."),2)).Result;First(Split('Datum nakládky';".")).Result) >=(DateAdd(Now();-2;Days)) And Date(Last(Split('Datum nakládky';".")).Result;Last(FirstN(Split('Datum nakládky';"."),2)).Result;First(Split('Datum nakládky';".")).Result) <= (DateAdd(Now();10;Days) );

Best Regards,

Bof
TomasG 255 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-bofeng-msft,

thanks for replay. I try it, but there is some problem. I think it ist caused by time value of datetime. Column in SP is date and time column.

There some error message "2022 16:00 could not be convert"
Verified answer

victorcp 2,350 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi,
In your cenario I think you want to show all item that has any date between your time range right? if so there are 3 conditions that you have to consider:
1 - start date is between the time range
2 - end date is between the time range
3 - the time range is between start and end date
in this case the filter will be something like this:
With({Less2Days: DateAdd(Now(),-2,Days), Plus10Days:DateAdd(Now(),10,Days)}, Filter( dates, Start>=Less2Days && Start<=Plus10Days || // check if start date is between the time range End>=Less2Days && End<=Plus10Days || // check if end date is between the time range Start<=Less2Days && End>=Plus10Days // Check if time range is between start and end date ) )

I hope it helps 🙂
TomasG 255 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

thanks for help. This is correct sollution.