Unanswered

PowerApps - Filter by Date greater than Today-30

(0) Share

Report

Posted on by Wilder1626

Hi everyone.

In my PowerApps application, i'm pulling from Oracle some records into my DataTable. Once of the columns is the " STRT_DTT" for the Start date. The format of that field is: "Saturday, March 20, 2021 04:30:00 AM".
My goals is to be able to filter the records based on that file. I need to filter all records where STRT_DTT is >= Today(),-31,Days.

Bot for some reason, it does not work.
Last thing I've tried was:

(Text(STRT_DTT,DateTimeFormat.LongDate) >= Text(Today(),DateTimeFormat.LongDate)-31)

I have also tested below, but still not pulling any records.

I've created a new Textbox called: tx30DaysAgo
The default field equals to below code:

Text(DateAdd(DatePicker1_2.SelectedDate,-30,Days),DateTimeFormat.LongDateTime)

That gives me the same format and -30 days, it equals to: "Thursday, February 18, 2021 12:00:00 AM"

Now i update the data query with:

STRT_DTT > Value(tx30DaysAgo.Text)

But nothing, no results what so ever, and without any errors.

Can you please help me? Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (0)

Sort by

Pstork1 69,521 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!
I believe the problem is that your use of Text() turns the values into text strings rather than DateTime Values. YOu shoudl try using a simple filter like

Filter(datasource,STRT_DTT<= DateAdd(DatePicker1_1.SelectedDate,-31))

If the condition complains that STRT_DTT is text then enclose STRT_DTT in a DateTimeValue() function.

Was this reply helpful? Yes No
Wilder1626 89 on at

Like (0)

Report
Copy link

Link copied!

Thanks for your help.
I've tested below. I don't have any error but still no records. Kind of weird.

Sort(
Filter(
'[APIBATCH_QUE_T]',
STRT_DTT> DateAdd(DatePicker1_1.SelectedDate,-31)
),
STRT_DTT,
Descending
)

I also see that "DateAdd(DatePicker1_2.SelectedDate,-31)" format is the same as what i see in the STRT_DTT column.

Was this reply helpful? Yes No
Wilder1626 89 on at

Like (0)

Report
Copy link

Link copied!

I don't know if this tells you something, but i may have an error:

Was this reply helpful? Yes No
Wilder1626 89 on at

Like (0)

Report
Copy link

Link copied!

If i do something like: STRT_DTT < STRD_DTT, that works since. I guess that since both columns had the same formats, it does it.

But if i do: STRT_DTT> DateAdd(DatePicker1_1.SelectedDate,-31), That does not work at all.

So probably that i need to find the real STRT_DTT format.
In the Data Table STRT_DTT column Text field, i see: Text(ThisItem.STRT_DTT,DateTimeFormat.LongDateTime)

Was this reply helpful? Yes No
Pstork1 69,521 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

As I mentioned. If it doesn't work using STRT_DTT you may have to enclose it in DATETimeValue() to make sure its evaluated as a Date.

Was this reply helpful? Yes No
Wilder1626 89 on at

Like (0)

Report
Copy link

Link copied!

Sorry, i'm brand new on PowerApps since the last 2 weeks. I had to search on google for some DataTimeValue samples. So am I on the right track when i say below?
DateTimeValue(Text(STRT_DTT,"[$-en-US]dd-mm-yyyy hh:mm:ss"),"en-US")

Was this reply helpful? Yes No
Pstork1 69,521 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Yes, that should change the data type back from a string to a DateTime. That can then be used to filter with the DateAdd()

Was this reply helpful? Yes No
Wilder1626 89 on at

Like (0)

Report
Copy link

Link copied!

Thanks for confirming.

I've done the update now, but I suddenly have a "Delegation warning. This part "Filter" of this formula might not work correctly on large data sets." Also it does not give me any results.

Text( STRT_DTT, "[$-en-US]dd-mm-yyyy hh:mm:ss" ) ) > DateAdd( DatePicker1_2.SelectedDate, -31 );

Was this reply helpful? Yes No
Pstork1 69,521 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Whenever you start modifying the left side of the condition you are going to get a delegation warning. The only way to avoid that is to use STRT_DTT by itself as a column. But you said that doesn't work. I'm not familiar enough with Oracle to be able to tell you why. But to do the filter you want you have to be evaluating two DateTime variables.

Was this reply helpful? Yes No
Wilder1626 89 on at

Like (0)

Report
Copy link

Link copied!

It make sense to me. Will continue to look at it, and will let you know you if any progress.
Thanks again for your help. I've learned new things today.

Was this reply helpful? Yes No