Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 562
  • Last Modified:

Cross Tab - Changing week

Using CR 2008

I have a cross tab, with the column as date for each week

The week runs from Sunday to Saturday and the date printed in the column heading is the first day of the week Sunday i.e. this week 9th Sep

Our week runs from Monday to Sunday, which is how I want the cross tab to work.

Is there a formula I can use to implement Monday to Sunday instead of Sunday to Saturday?

1 Solution
Where does the start of week date come from currently?
Create a formula

{YourDateField} - (DayOfWeek ({YourDateField},crMonday))

use this formula in your crosstab instead of your current date field and set to evaluate for every day

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now