Hello, iโm creating a Weekly User specific timesheet for the users of an app. Each user should be able to see his/her own entries only (easily done using [USER_UID] = USEREMAIL()) and only for each new week (Monday - Sunday).
How will I only show each weekโs entries? Iโm tracking the DateTime the entries are created but something like DATE + 7 wouldnโt work because if you log an entry on Saturday it will last till next Saturday. Should I check if the creation date is between this Mondayโs date & this Sundayโs date? How can I know this weekโs Monday & Sunday date?
Solved! Go to Solution.
You can do that with the EOWEEK() expression. Have you checked that?
You can do that with the EOWEEK() expression. Have you checked that?
I didnโt know about it. Thank you! So if the week starts on Monday (for me) & ends on Sunday, would that be
AND(DATE([CreatedDate]) >= EOWEEK(DATE([CreatedDate]) - 5),DATE([CreatedDate]) <= EOWEEK(DATE([CreatedDate]) + 1))
?
For reference:
For example yes.
User | Count |
---|---|
43 | |
28 | |
24 | |
24 | |
13 |