Link to home
Create AccountLog in
Avatar of Maliki Hassani
Maliki HassaniFlag for United States of America

asked on

Crystal Reports: Formula needed for weekly date ranges ie (12/31-01/06)

Hello Experts,

I have a question pertaining to displaying date ranges.   I have a week over week chart that shows weekly stats.  So it looks like week 1, week 2, week 3, week 4, etc ....

Instead of of having titles as week XX, I want to show Week 1 as 12/31-01/06, Week 2 as 01/07-01/13. etc   My weeks are considered Monday through Sunday.

Any idea how this can be achieved (Formula)?

Thanks!!
ASKER CERTIFIED SOLUTION
Avatar of peter57r
peter57r
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
Avatar of Maliki Hassani

ASKER

Excellent..  Let me give this a try. As for the sequential order of the chart will be challenging. Still thinking about how I can do this..
Excellent- Just what i needed.. Thank you