Converting Date into DaysOfWeek

[aliabid]

Hi all,

I'm making a chart on a field with data type Date & Time. I want to display the day of week in chart rather than whole Date. How can I do it?

Thanks in advance.

Regards,

Abid.

 

[kenhamady]

What version of CR?
Is the chart a Detail/Advanced Chart or a Group chart? (See data tab) Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.

 

[aliabid]

The CR version is 7.0

I'm using Detail Chart.

Abid.

 

[kenhamady]

Write the following formula field:

If DayOfWeek({Orders.Ship Date}) = 1 then "Sunday" else
If DayOfWeek({Orders.Ship Date}) = 2 then "Monday" else
If DayOfWeek({Orders.Ship Date}) = 3 then "Tuesday" else
.......else "Saturday"

Now use that for your on-change-of field in the chart. Use the "ORDER" button under the on-change-of to put the days in the correct order, using the 'specified' option. Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.