AnsweredAssumed Answered

Previous week's date

Question asked by cyrilkaye on Sep 18, 2018
Latest reply on Sep 20, 2018 by philmodjunk



This is what I do to be able to get the range of date that I needed for that week.

But I want it to be automated, like in just a press of a button I could grab the date from last week.

Monday to Sunday, I saw some articles but they just subtract 7 from the current date.

I want it grab the whole week's date range (Monday to Sunday) no matter what day it is, even if it's Wednesday.

Should I do a Case Statement?

Case( Field = MondayCurrentDate - 7) If it is a Tuesday it would be minus 8 , Wednesday minus 9?


Then after that I want to have a field where in I will have the Days between Dates that occurred on the field.

If an employee is 1 day absent on that week they will only get 4 days.


But the thing is the field has a lot of identical values, can I filter it?

All 8.28.18 that appeared will be counted as 1 date only.


I don't know If I stated it clearly.

Screen Shot 2018-09-18 at 2.25.00 PM.png

Screen Shot 2018-09-18 at 2.24.39 PM.png