[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Day of Week formula?...Monday, Tuesday, etc...

Posted on 2009-05-13
2
Medium Priority
?
898 Views
Last Modified: 2012-05-06
Using Crystal Reports XI

How do I return the name of the day (Monday, Tuesday, Wednesday, etc...)?  I have a field called {trade.maturity}, which is the field for the maturity date for a financial trade.  I want to create a formula that looks at that field and returns the corresponding Day in string format.

Thanks!

Brian
0
Comment
Question by:IO_Dork
2 Comments
 
LVL 9

Accepted Solution

by:
wellhole earned 2000 total points
ID: 24378645
Do something like this

["Sun", "Mon", "Tues",.................] [DayOfWeek(your-date)]
0
 

Author Closing Comment

by:IO_Dork
ID: 31581181
Wow, that was easy!  Thanks!!
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Integration Management Part 2
Screencast - Getting to Know the Pipeline
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question