Joined: 17 Jun 2012
Location: Australia
Online Status: Offline
Posts: 1
Topic: Change Start day of week to Wednesday Posted: 17 Jun 2012 at 7:30pm
Hi Everyone
I am new in Crystal Report. Can anyone please help to give
some suggestion on how to change the first day of week from the Default Sunday
to Wednesday in Crystal Report 2008?
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Posted: 18 Jun 2012 at 4:31am
This gets a bit complicated and a lot of it depends on what you're trying to do. If you just want to group by week, you can do something like the following:
If DatePart('w', {table.date_field}) in 1 to 3 then DatePart('ww',{table.date_field}) - 1
else DatePart('ww', {tabloe.date_field})
The 'w' format in DatePart gets you the day of the week and the 'ww' format gets you the week number in the year.
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
IP Logged
