Week of Month - Mon-Sun 1

[jcl5]

I am using this formula in my report to group by week of month but I need Monday to be the first day of the week.
Can anyone help please?

Datepart("ww",{LINKS.LINK_DATE})+1
- Datepart("ww",{LINKS.LINK_DATE} - Day({LINKS.LINK_DATE})+1)

Thanks

jcl5

 

[nagornyi]

DatePart("ww",{LINKS.LINK_DATE}, crMonday)

 

[lbass]

You can use a third argument to specify the dayofweek:

datepart("ww",{table.date},2)

A fourth argument can be used to specify the first week of the year. The default is "1", which is the week that January 1 falls in. See CR help for details.

-LB

 

[jcl5]

Thanks for this - can you also tell me how to display the date of the first day of each week?

 

[nagornyi]

{LINKS.LINK_DATE}-DayOfWeek({LINKS.LINK_DATE})+1