Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shm
Yak Posting Veteran
86 Posts |
 Posted - 2009-03-04 : 00:23:11
|
| hii have to change the format of the date as 10-Mar-09 i have given like this =Iif(Fields!EST_START_DATE.Value is nothing,nothing,Cdate(Fields!EST_START_DATE.Value).ToString("d-MMM-yy"))it is coming but if i export the report to excel and select the date it wil be in the format *3/14/2001 format i dnt want this format i want 14-Mar-01 formathow to change the date vlaue?in the layout |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-03-04 : 10:17:53
|
| no need of any IIF expression . just use expression as=Cdate(Fields!EST_START_DATE.Value)and in cell properties,format tab, give expression for format as="d-MMM-yy" |
 |
|
|
shm
Yak Posting Veteran
86 Posts |
Posted - 2009-03-05 : 00:30:05
|
| hii gave IIf expr because if the value is null and if i give the Cdate() the value will come as 01-jan-0001 for null values so i want to display the null only so i used IIF epxr you had only given that sol... to display null as it is onlyno i tried that only using CDate() but again it is not coming like that |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-03-08 : 13:16:07
|
| then give a IIf expression for format also=IIF(Me.Value Is Nothing,Nothing,"d-MMM-yy") |
|
|
|
|
|
|
date format in the layout