0

# Need to group days of the week from a payroll calendar perspective

Jul 31, 2017 at 08:30 PM

41

Former Member

I am trying to define pay periods but cannot figure it out. I am using:

if {reportexport.Date} = Date(2017,01,1) then "Week 00" else
if {reportexport.Date} = Date(2017,01,1) then "Week 00" else
if {reportexport.Date} = Date(2017,01,2) then "Week 00" else
if {reportexport.Date} = Date(2017,01,3) then "Week 00" else
if {reportexport.Date} = Date(2017,01,4) then "Week 00" else
if {reportexport.Date} = Date(2017,01,5) then "Week 01" else
if {reportexport.Date} = Date(2017,01,6) then "Week 01" else
if {reportexport.Date} = Date(2017,01,7) then "Week 01" else
if {reportexport.Date} = Date(2017,01,8) then "Week 01" else
if {reportexport.Date} = Date(2017,01,9) then "Week 01" else

But cant I just say something like if reportexport.date is between date1 and date 2 then "week 1"

Vitaly Izmaylov
Aug 25, 2017 at 05:27 PM
0

There is an option to Group Weekly:

1. Group records by date field

2. Go to Report > Group Expert > select the Date Group > Click Options at the bottom > Select The section will be printed for each week

Share
Vitaly Izmaylov
Aug 25, 2017 at 05:34 PM
0
Share
Ian Waterman Aug 29, 2017 at 09:29 AM
0

There is a week number function in Crystal

DATEPART("ww",{reportexport.Date}, crSunday)

Group on this formula

Ian

Share