tags:

views:

713

answers:

2
Q: 

Crystal Reports DateTime Formatting

Hello,

I'd like to format a datetime in Crystal Reports to a include the day of week.

From:

19/06/2009

To:

Friday, June 19, 2009

Thanks,

+2  A: 

In Crystal Reports XI Release 2 you can right click on the field and go to Format Field. On the "Date and Time" tab click the customize button. Under the Date Tab change the Date Type drop down to "Windows Default Long".

Dusty  2009-06-11 15:14:52
Is there anyway to implement this formatting in a formula? IE: I have two database fields that I want to combine into one Crystal Reports field.
Nathan Koop  2009-06-11 16:37:12
I put another answer on here for this question to help other people with this same issue since (if people are like me) they generally don't really read the comments. If you want to do that you can just concatenate two functions similar to the second answer together in a formula field.
Dusty  2009-06-11 17:37:00
+2  A: 

If in a formula, you can use the following.

CSTR({?@end_dt}, "dddd, MMMM d, yyyy")

Dusty  2009-06-11 16:54:28

related questions

Handling and storing elapsed time
How do I convert local time to UTC in Python?
Mono's DateTime Serialization
Best practices for DateTime serialization in .Net framework 3.5/SQL Server 2008
Parsing exact dates in C# shouldn't force you to create an IFormatProvider
C# Casting vs. Parse
.NET Date Const (with Globalization)
Dynamic regex for date time formats
What is the simplest way to find the difference between 2 times in python?
Best way to convert DateTime to "n Hours Ago" in SQL
What's a good way to overwrite DateTime.Now during testing?
Datetime arithmetic with a string in Ruby
How can I get the DateTime for the Start of the Week?
Is DateTime.Now the best way to measure a function's performance?
SQL Server DateTime conversion failure
Natural language date/time parser for .NET?
What's a good way to check if two datetimes are on the same calendar day in TSQL?
Why does this python date/time conversion seem wrong?
Dealing with PHP server and MySQL server in different time zones
How do I parse and convert DateTime's to the RFC 3339 date-time format?
HOWTO - Compare a date string to datetime in SQL Server?
Best method for varchar date validation in Sybase (T-SQL)?
What's the BEST way to remove the time portion of a datetime value (SQL Server)
How do I calculate relative time?
How do I calculate someone's age in C#?