Crystal Reports Change first day of week

Report Design
Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design

Topic: Change first day of week

Author	Message
Trisha22191 Newbie Joined: 15 Apr 2008 Online Status: Offline Posts: 10	Topic: Change first day of week Posted: 22 Sep 2008 at 10:08am
	Hi. I am wondering how to change the first day of the week from default of Sunday to Friday? I've been looking and I cannot find the answer. thanks.
	IP Logged

tdrio Newbie Joined: 07 Aug 2008 Location: Portugal Online Status: Offline Posts: 5	Posted: 22 Sep 2008 at 11:30am
	Hi, You can use the function DayOfWeek (date, firstDayOfWeek), and specify the 1th day of the week you want DayOfWeek(CurrentDate, crMonday) result 1; Monday is 1th day of week DayOfWeek(CurrentDate, crSunday) result 2; Monday is 2nd day of week Regards
	IP Logged

Trisha22191 Newbie Joined: 15 Apr 2008 Online Status: Offline Posts: 10	Posted: 22 Sep 2008 at 11:52am
	is it as simple as creating a separate function to change it. or do i need to do this with a date function i already have?
	IP Logged

Trisha22191 Newbie Joined: 15 Apr 2008 Online Status: Offline Posts: 10	Posted: 22 Sep 2008 at 12:03pm
	i am grouping on labor entry date (startdate). I then need to be sure the totals for this group are within the pay week (Friday to Thurs). Since CR defaults the start of week to Sunday, when I run my calculations it bases it on Sunday to Saturday, making my figures off. I need to know where I would change the first day of the week to Friday.
	IP Logged

Post Reply

Post New Topic

Printable version

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

This page was generated in 0.031 seconds.