sqlcurious
asked on
Trying to change time format in SSRS
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!Birt hDate.Valu e, 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
So, I tried changing in the report under Expr->Common functions->date time -> FormatDateTime(Fields!Birt
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks
ASKER
As Alpesh gave the full expression icouple mentioned about the double quotes. So, the answer that
worked for me was:
=IIF(ISnothing(Field.Value