troubleshooting Question

Trying to change time format in SSRS

Avatar of sqlcurious
sqlcuriousFlag for United States of America asked on
Microsoft SQL ServerSSRS
4 Comments2 Solutions1336 ViewsLast Modified:
Hi Experts, I tried to change the format of the date for ex: '2001-08-21 00:00:00.000' in the stored procedure by doing convert function. It works fine when I execute the sp but when I look at the report it still shows '2001-08-21 00:00:00.000' format.
So, I tried changing in the report under Expr->Common functions->date time -> FormatDateTime(Fields!BirthDate.Value, DateFormat.ShortDate), though its working for all the dates but then the null values are coming out to be '1/1/0001', I am not understanding that, can you please help.
Thanks
ASKER CERTIFIED SOLUTION
itcouple

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros