Report Manager Date Format

Last Post 27 Apr 2006 01:04 PM by ceccato. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
clister
New Member
New Member

--
17 Oct 2005 11:36 PM
Hi,
I have a report project setup. I am based in Ireland and have regional settings and date format set to dd/mm/yyyy. My report is designed with this date format. When I enter the dates through the Report Manager published report and pass the date as a parameter to another report, the report manager seems to be converting the date to US format so that the date 31 aug 2005 (31/08/2005) is being seen as 08/31/2005 and therefore not recognised as a correct or valid value.

Can you suggest a solution to this issue?

Thanks and Regards,

Rena Garrett
ceccato
New Member
New Member

--
27 Apr 2006 01:04 PM
Hi,
could you solve this problem? I have the same!
Can you help me?

Leandro
xfonhe
New Member
New Member

--
28 Apr 2006 06:29 AM
Look up CONVERT() function in BOL... region codes are included in the function (103 = British/French; 110 = USA, etc).

Sample: select convert(varchar(10),getdate(),103) as date

result:
DATE
-------------
28/04/2006

select convert(varchar(10),getdate(),110) as date

result:
DATE
-------------
04-28-2006


X
You are not authorized to post a reply.

Acceptable Use Policy