how can i change the week to monday through sunday?
i've spent many hours in the timecard crytal report and it keeps coming up sunday - saturday
timecard crystal report
Jun 27, 2005
5 Replies
you can't.
Cheeseplus,
You need to edit several fields: Change WeekEndDate to: {@DateIn} + 8 - DayOfWeek ({@DateIn}) and WeekStartDate to: {@DateIn} + 2 - DayOfWeek ({@DateIn}) Each of the days of the week Headings, add a day and change the name to the next day. i.e. Change HeadingSun from: DateVar ThisDate := {@DateIn} + 1 - DayOfWeek ({@DateIn});
"Sun " + ToText(Month(ThisDate), 0) +"/" + ToText(Day(ThisDate), 0)
to... DateVar ThisDate := {@DateIn} + 2 - DayOfWeek ({@DateIn});
"Mon " + ToText(Month(ThisDate), 0) +"/" + ToText(Day(ThisDate), 0)
Then run the report with the filter: DateIn Between June 13 2005 to June 19 2005
Rob
We have one based on a access. If you want that one sent to you please email me snipped-for-privacy@stepahead-educational.com
yes, please anything you might offer would be helpful
thanks
-ray
"Elizabeth" wrote:
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required