cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance on the Date Filters

Hi,

 

I am preparing a dashboard whereby I can view my records based on week. It seems like there is no formula that allows me to match by Week. Similar to Excel we can filter by This Week, Next Week.. etc.

 

So will be good to have these formula added.

 

Thank You

Boon Yar

Status: Planned
Comments
PowerApps Staff

You could use the DateDiff function to see how many days away from Now your date is, and if less than 7 then it is this week, if 7-14 then next week, etc.

Level: Powered On
Hi Andy,

Yup thanks. I did that way already. Just thought it will be good to have these predefined filters or formulas for ease of use.

Cheers
Boon yar
Flow Staff
Status changed to: Planned
 
Level: Powered On

Thanks! Thats great!