1877176 - How to find the date of the first day of the week from Crystal Reports

SAP Knowledge Base Article - Public

# 1877176- How to find the date of the first day of the week from Crystal Reports

### Symptom

How to find the date of the first day of the week from Crystal Reports?

### Environment

• Crystal Reports 2008
• SAP Crystal Reports 2011

### Resolution

Create a Crystal Report having a formula with the following code:

datevar x := {datefield};  // datefield represent the field from the database

If DayOfWeek(x) = 1 Then

x

Else If DayOfWeek(x) = 2 Then dateadd ("d",-1,x)

Else If DayOfWeek(x) = 3 Then dateadd ("d",-2,x)

Else If DayOfWeek(x) = 4 Then dateadd ("d",-3,x)

Else If DayOfWeek(x) = 5 Then dateadd ("d",-4,x)

Else If DayOfWeek(x) = 6 Then dateadd ("d",-5,x)

Else If DayOfWeek(x) = 7 Then dateadd ("d",-6,x)

### Keywords

Crystal reports, Date, Week, First, Day , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

### Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011