Technical Questions: Formula for finding the day name given the date

Print Page | Close Window

Formula for finding the day name given the date

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=2837
Printed Date: 06 May 2024 at 4:05am

Topic: Formula for finding the day name given the date

Posted By: jon2ryhme
Subject: Formula for finding the day name given the date
Date Posted: 07 Apr 2008 at 7:38am

Hi everyone,

To find the week day name from the given date,
use the following formula.

@f_Day_Name:

CStr (DateValue ({Orders.Order Date}))+ "-" +WeekdayName (DayOfWeek ({Orders.Order Date}))

The output will be like this.

1/1/2004 - Thursday

I hope this helps someone.

Is there any alternative way for doing this?
If so please reply.

Thanks in advance
jon2ryhme

Print Page | Close Window