Filter the data of current month using dates

Please help to make a slice that show the data fallen within the current month

Start Date                End Date             Utilization Percentage
01-Feb-2022           28-Feb-2022                          20
3-Jan-2022             31-Dec-2022                           40
16-Feb-2022           15-Feb-2023                           80

 

 2 & 3 rows dates are fallen in this month so it should be show in the view and It should exclude 1st row which date has already gone.

Solved Solved
0 3 933
1 ACCEPTED SOLUTION

Maybe

AND( [Start Date]<=TODAY()  ,

[End Date]>=TODAY()  )

View solution in original post

3 REPLIES 3

Maybe

AND( [Start Date]<=TODAY()  ,

[End Date]>=TODAY()  )

Sir, the solution given by you is correct and it is filtering the data accordingly! But as you have earlier suggest me for creating the slice and a virtual column to show the sum of Utilization Per Employee. I have added this expression with earlier which was suggested by you to make the slice, Now after adding both the expressions it looks  like something:-

AND([ID]=MINROW("RMG","_ROWNUMBER",[Employee Name]=[_THISROW].[Employee Name]), AND([Start Date]<=TODAY(),[End Date]>=TODAY()))

Now if I showing the test pane of this expression it exclude the rows that are fallen in this month.

 

As well as you have also suggest me to create the virtual column for showing the sum of Utilization Per Employee which is:-

SUM(SELECT(RMG[Utilization Percentage], [Employee Name]=[_THISROW].[Employee Name])) 

 

The Main problem is that I want to create a view that show sum of Utilization of Per employee according to start date and end date column, If End Date is less than Today then it should not add the value of that Row.

 

Please help to modify these Expressions

This way it's going to take into account the day, so the third row will be excluded on 16-feb-2023

AND(
  [Start Date]<=TODAY(),
  [End Date]>=TODAY()
)

Now, if you need to include the data the whole month, eventhough it's start and end is at the middle of the month, try:

AND(
  EOMONTH([Start Date], -1)<TODAY(),
  EOMONTH([End Date], 0)>=TODAY()
)

https://help.appsheet.com/en/articles/2430932-eomonth

https://help.appsheet.com/en/articles/961346-date-and-time-expressions 

Top Labels in this Space