Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
"Date with Day"- Format in Crystal Reports 9
- Thread starter svetlana1
- Start date
IanWaterman
Programmer
Svetlana
I can only suggest that you sort or group your report on date field you want and then create a formula which breaks down date into elements you require, and then reassemble as a string.
eg
weekdayname(weekday({DATE}), true)
This brings back abbreviated day name
Totext(day({DATE}),0,""
This brings back Day number in month, the extra arguments remove decimal places and Thousand separators)
Hope this helps
Ian Waterman
UK Crystal Reports Consultant
I can only suggest that you sort or group your report on date field you want and then create a formula which breaks down date into elements you require, and then reassemble as a string.
eg
weekdayname(weekday({DATE}), true)
This brings back abbreviated day name
Totext(day({DATE}),0,""
This brings back Day number in month, the extra arguments remove decimal places and Thousand separators)
Hope this helps
Ian Waterman
UK Crystal Reports Consultant
I don't know about 9.0, but in 8.5, you can get that format by customizing the way your date field displays...
Right click on the date field > Format Field > on the Date/Time tab, click the Customize button and format the date as you described by using the available options.
-dave
Right click on the date field > Format Field > on the Date/Time tab, click the Customize button and format the date as you described by using the available options.
-dave
- Status
Similar threads
- Locked
- Question