Just sharing, group records by week

[NiceDuck]

Hello again,

I just want to share this workflow. 

In my tabular report, I want my records to be grouped by week but when I select the week rollup, it displays the weeknumber, (ex. week 1, week 2) instead of an actual date. Since I wanted to make it display the date of the first date of that week (ex, date of every sunday), I have made this workflow:

First, I created an extra date field, then, I created a triggered action/task to process the data. This is the pattern I used:





Then I used the extra field weekdate to group my records instead of using the "week rollup" function.

[NiceDuck]

I first tried using a formula field on that but I noticed that the DatePart "weekday" function is not usable on the formula field, thus I have to use a trigger instead.

Just sharing again, no problem here. feel free to comment if you have better suggestions.

quack

[kpcollier]

This is awesome. I needed a way to get the first and last dates of the current week (Sun/Sat) to include in the body of an email. All I had to do was throw this formula into a variable, duplicate it and add 6 days to the 2nd one. Now I can include the dates wherever I want in the email block. 

Many thanks, @NiceDuck