Skip to Content
Former Member
Dec 19, 2012 at 11:03 PM

Returning the date at the beginning of a week in the year


In Crystal Reports 2011, I'm trying to return the first day of the week in the date format m/d/yyyy for a specific week of a prior year. For example, December 2, 2012 is the 49th week of 2012 and begins on a Sunday. However 365 days prior to December 2, 2012 is a Saturday and still in the 49th week of 2011. Is there a function in Crystal that will allow for this? I've been unsuccessful in finding one. In the end, what I'm trying to do is to determine the sales for the same week of the prior year. Any help is appreciated!