Link to home
Create AccountLog in
Avatar of D_Bjerke
D_Bjerke

asked on

Crystal Reports - Need to Add date to the 1st Monday of the week

I am using a group to organize my expenses by week. My week goes from Monday to Sunday. This formula works great for grouping the data. But I need to add a date for the 1st or last day of the week.
Group Formula - DatePart ("ww",{Cornerstone_Solutions.Date},CrMonday)

Example May 13 (Monday) and May 19 (Last day of my week).

I would like May 13-19, 2013 to appear on the report in the Group Header #1. Currenly all I get is "20" because May 13-19 is the 20th week of the year I am guessing.

Any suggestions?
Avatar of Ido Millet
Ido Millet
Flag of United States of America image

Get the Day of the Week number, and subtract or add days accordingly to get the Monday or Saturday.
ASKER CERTIFIED SOLUTION
Avatar of Ido Millet
Ido Millet
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account