| Author |
Topic |
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
 Posted - 2008-01-29 : 03:15:16
|
| My regional settings are set to the UK on the server and local machine. Does anyone know how to get SSRS displaying dates in DD/MM/YYYY format?I have googled it, but just can not seem to find the answer. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-01-29 : 03:43:28
|
| You can use FormatDateTime function in SSRS or select format from format tab of column properties. Also check whether you have set the language settings of report to English UK. |
 |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-01-29 : 04:07:47
|
Thanks, it was the report language.  Is there any way I can default this to UK? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-01-29 : 04:16:50
|
| I think this is set during installation of SSRS |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-01-29 : 05:46:53
|
| Hmmm, I don't remember seeing it, does it take the regional settings at the time as I think they may have been US? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-01-29 : 06:03:13
|
| Refer this:-http://msdn2.microsoft.com/en-us/library/ms156493.aspx |
|
|
|
praveenbattula
Starting Member
4 Posts |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2010-01-18 : 05:04:56
|
| I dunno, why would I need anything 2 YEARS after i'd asked the question? Suppose it may help others.. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-01-18 : 06:18:47
|
quote:
Originally posted by RickD
I dunno, why would I need anything 2 YEARS after i'd asked the question? Suppose it may help others..
Now-a-days almost all the first time posters reply to the very old topics  Howver did you find a solution without using a custom function?MadhivananFailing to plan is Planning to fail |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2010-01-18 : 06:30:45
|
| Yeah, I'm sure I did as got it all working at the time. Don't ask me how after all this time as I can't remember what I done yesterday sometimes.. |
|
|
|
|
Displayed Date Format in SSRS?