Date Format

My date is being returned as mm/dd/yyyy - how do I format this to be
dd/mm/yyyy. My region setting are UK.
ThanksSome of the region settings didnt work correctly in the initial version
of Sql Server 2000 Reporting Services. "I think" that they were fixed
in either SP-1 or SP-2.
However, as a temporary work around you can explicitly set the date
format on each report item by selecting the table-cell, textbox, or
field you want to format and going to Properties to set the "Format"
property. The format string should simply be the date format you
prefer such as "DD/mm/yyyy" (without quotes).
Hope this helps,
Lance Hunt
http://www.lance-hunt.net/|||"Mike R" <news@.mikeread.freeserve.co.uk> wrote in message
news:d99959$3lb$1$8302bc10@.news.demon.co.uk...
> My date is being returned as mm/dd/yyyy - how do I format this to be
> dd/mm/yyyy. My region setting are UK.
> Thanks
>
Found my solution..
http://www.eggheadcafe.com/articles/20040823.asp|||"Lance" <lancehunt@.gmail.com> wrote in message
news:1119365398.406661.173780@.g43g2000cwa.googlegroups.com...
> Some of the region settings didnt work correctly in the initial version
> of Sql Server 2000 Reporting Services. "I think" that they were fixed
> in either SP-1 or SP-2.
> However, as a temporary work around you can explicitly set the date
> format on each report item by selecting the table-cell, textbox, or
> field you want to format and going to Properties to set the "Format"
> property. The format string should simply be the date format you
> prefer such as "DD/mm/yyyy" (without quotes).
> Hope this helps,
> Lance Hunt
> http://www.lance-hunt.net/
>
Thanks Lance, If found this http://www.eggheadcafe.com/articles/20040823.asp
when resolves my issue.
Kind Regards
Mike