CAN DATES BE CHANGED TO TEXT????

[samsunguser]

is it possible to change dates e.g. 01/11/04 to a day e.g Friday? I need to do a report based on how many requests have been logged each Saturday - but our helpdesk database logs these days as dates. How would I do this???

 

[Crystalyzer]

Sam,

You can do this easily by formatting the date field. Go to Format Field\Date\Customize and set the Format "Month" to none, Day to none and year to none. Then select the "Day of Week" to long.


You could also use a formula to "convert" to the day of week name as follows:

WeekdayName (DayOfWeek(Date(yyyy,mm,dd)))

et voila!

Lloyd

 

[dgillz]

WeekdayName(DayofWeek(({YourDateField})))

Should work nicely.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
askdon@srhconsulting.com

http://www.srhconsulting.com