InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 04:53:51 GMT20http://www.sqlservercentral.com/Forums/Topic290724-150-1.aspx[quote][b]Carolyn Richardson (1/24/2008)[/b][hr]There is a simpler way, by default reporting services are installed using English (United States) as the default date format adjust the Report properties language to English (United Kingdom)[/quote]This worked perfectly for me. Thanks!!! I also set the format to 'd' an you get a short date 'dd/mm/yyyy'.Tue, 27 Nov 2012 19:14:18 GMTthepotplantshttp://www.sqlservercentral.com/Forums/Topic290724-150-1.aspx[quote][b]Sjeef (10/3/2012)[/b][hr][quote][b]shelts (9/28/2012)[/b][hr]Yes I know that but for each new report the date format reverts back to US with the month first. The easiest way around it I've found so far is setting the language at Report level for each new report which at least avoids the need to change it for each date field in the report set up in Report Builder![/quote]Why not making 1 report template with the most settings right in it.And start every new report based on this template.?Thats the way i create my reports.I have a standard header and footer, my language is set to Belgium locale.So i don't have to worry about those small items all over again.Wkr,Eddy[/quote]And this is a guaranteed way to avoid the unintended consequences law that you would invoke by changing server settings.Thu, 04 Oct 2012 08:13:20 GMTBrandie Tarvinhttp://www.sqlservercentral.com/Forums/Topic290724-150-1.aspx[quote][b]shelts (9/28/2012)[/b][hr]Yes I know that but for each new report the date format reverts back to US with the month first. The easiest way around it I've found so far is setting the language at Report level for each new report which at least avoids the need to change it for each date field in the report set up in Report Builder![/quote]Why not making 1 report template with the most settings right in it.And start every new report based on this template.?Thats the way i create my reports.I have a standard header and footer, my language is set to Belgium locale.So i don't have to worry about those small items all over again.Wkr,EddyWed, 03 Oct 2012 23:39:13 GMTVan Heghe Eddyhttp://www.sqlservercentral.com/Forums/Topic290724-150-1.aspx[quote][b]shelts (9/28/2012)[/b][hr]Yes I know that but for each new report the date format reverts back to US with the month first. The easiest way around it I've found so far is setting the language at Report level for each new report which at least avoids the need to change it for each date field in the report set up in Report Builder![/quote]This sounds like a server level language issue. Have you checked to make sure your server language / collation is set up for British or European standards and not U.S. standards?Wed, 03 Oct 2012 04:02:24 GMTBrandie Tarvinhttp://www.sqlservercentral.com/Forums/Topic290724-150-1.aspxYes I know that but for each new report the date format reverts back to US with the month first. The easiest way around it I've found so far is setting the language at Report level for each new report which at least avoids the need to change it for each date field in the report set up in Report Builder!Fri, 28 Sep 2012 03:58:33 GMTsheltshttp://www.sqlservercentral.com/Forums/Topic290724-150-1.aspxSet custom format as MMMM dd, yyyyHope this will help.Thanks,AjayFri, 28 Sep 2012 03:00:53 GMTajaykdhttp://www.sqlservercentral.com/Forums/Topic290724-150-1.aspxThanks For post so usfulFri, 27 Jul 2012 06:34:20 GMTj.sivashankar1987http://www.sqlservercentral.com/Forums/Topic290724-150-1.aspxplease add this code in your experssion.=Format(Parameters!FromDate.Value ,"MMMM dd, yyyy")Thu, 26 Apr 2012 05:29:46 GMTbisoyi.jogeswarahttp://www.sqlservercentral.com/Forums/Topic290724-150-1.aspxplease add this code in your expression=Format(Parameters!FromDate.Value ,"MMMM dd, yyyy")Thu, 26 Apr 2012 05:28:23 GMTbisoyi.jogeswarahttp://www.sqlservercentral.com/Forums/Topic290724-150-1.aspx[quote][b]shelts (2/22/2012)[/b][hr][quote][b]Carolyn Richardson (1/24/2008)[/b][hr]There is a simpler way, by default reporting services are installed using English (United States) as the default date format adjust the Report properties language to English (United Kingdom)[/quote]Yes that works but the time portion of the date remainsIs there anyway to change the default from displaying 22/02/2012 00:00:00:00 other than going into each field as all we wish to display is 22/02/2012Thanks[/quote]You can convert it to a string and only pull out the first 10 digits. Or (in 2008) try using the Date datatype.Wed, 22 Feb 2012 10:40:40 GMTBrandie Tarvinhttp://www.sqlservercentral.com/Forums/Topic290724-150-1.aspx[quote][b]Carolyn Richardson (1/24/2008)[/b][hr]There is a simpler way, by default reporting services are installed using English (United States) as the default date format adjust the Report properties language to English (United Kingdom)[/quote]Yes that works but the time portion of the date remainsIs there anyway to change the default from displaying 22/02/2012 00:00:00:00 other than going into each field as all we wish to display is 22/02/2012ThanksWed, 22 Feb 2012 09:11:42 GMTsheltshttp://www.sqlservercentral.com/Forums/Topic290724-150-1.aspxThe 'DD MMM YYYY' format does not work correctly when setting a default value to a date parameter! As soon as the report is previewed, the date reverts back to MM/DD/YYYY which is particularly frustrating. I know with BIDS 2005, the fix was to set the language on IIS (which seemed to override every other local setting)... so what's the fix now for Windows 7?Thu, 02 Feb 2012 16:10:55 GMTbrendan.eilola 4456http://www.sqlservercentral.com/Forums/Topic290724-150-1.aspxFORMAT(now,"dd/MM/yyyy")Thu, 19 Jan 2012 09:27:29 GMTConfickerhttp://www.sqlservercentral.com/Forums/Topic290724-150-1.aspxThank you that was really helpinWed, 09 Nov 2011 06:52:22 GMTkameshshahithttp://www.sqlservercentral.com/Forums/Topic290724-150-1.aspxSee attached spreadsheet with ExamplesMon, 22 Nov 2010 07:25:42 GMTEdward Boyle-478467http://www.sqlservercentral.com/Forums/Topic290724-150-1.aspxThe [b]Format [/b]function is locale aware and can be used as follows [not the case senstivity]Set [b]Language=User!language [/b]in the [b]Report properties[/b] and use the Format function with the following codes:[b]Standard Format Specifiers for Dates and Times:[/b]The table below shows the standard date and time formatters.Format Description Example [b]d[/b] Short Date [b]D[/b] Long date [b]f[/b] long date & short time [b]F[/b] long date and long time [b]g[/b] short date and short time [b]G [/b] short date and long time [b]M or m[/b] month and day [b]Y or y[/b] year and month [b]t [/b] short time [b]T[/b] long time [b]s[/b] displays in ISO 8601 format using local time [b]u[/b] displays in ISO 8601 format using universal time [b]U [/b] date and time in unversal time [b]R or r [/b] displays in RFC 1123 format [b]Custom formatting sequences:[/b]There are also specific character sequences that can be used to achieve custom formatting of dates and times. Format Description [b]d [/b] day of month (1 or 2 digits as required) [b]dd[/b] day of month (always 2 digits, with a leading 0 if needed) [b]ddd [/b] day of week (3 letter abbreviation) [b]dddd [/b] day of week (full name) [b]M [/b] month number (1 or 2 digits as required) [b]MM [/b] month number (always 2 digits, with a leading 0 if needed) [b]MMM[/b] month name (3 letter abbreviation) [b]MMMM[/b] month name (full name) [b]y [/b] year ( last 1 or 2 digits, no leading 0) [b]yy[/b] year (last 2 digits) [b]yyyy[/b] year (4 digits) [b]H[/b] hour in 24-hour format (1 or 2 digits as required) [b]HH [/b] hour in 24-hour format (always 2 digits, with a leading 0 if needed) [b]h [/b] hour in 12-hour format (1 or 2 digits as required) [b]hh[/b] hour in 12 hour format [b]m[/b] minutes (1 or 2 digits as required) [b]mm[/b] minutes (always 2 digits, with a leading 0 if needed) [b]s [/b] seconds (1 or 2 digits as required) [b]ss[/b] seconds [b]t [/b] first character in the am/pm designator [b]tt[/b] am/pm designator [b]z [/b] time zone offset, hour only (1 or 2 digits as required) [b]zz [/b] time zone offset, hour only (always 2 digits, with a leading 0 if needed) [b]zzz[/b] time zone offset, hour and minute [b]/ [/b] default date separator [b]:[/b] default time separator [b]\ [/b] escape characters Sun, 21 Nov 2010 07:53:16 GMTEdward Boyle-478467http://www.sqlservercentral.com/Forums/Topic290724-150-1.aspxThis is what worked for us. Use =User!Language under the Language Property for the report.Thu, 18 Nov 2010 14:28:55 GMTgary_nilsenhttp://www.sqlservercentral.com/Forums/Topic290724-150-1.aspxYou haven't offended. I just wanted to make sure you knew the proper behavior so you wouldn't have problems in the future.On the other hand, the poster hasn't responded to my questions or your post, so I have no idea if he resolved his problem or not.Tue, 16 Nov 2010 09:40:36 GMTBrandie Tarvinhttp://www.sqlservercentral.com/Forums/Topic290724-150-1.aspxThanks Brandie for correcting me. I apologize if I have offended anyone in anyway, it was never meant to. Apologies again, all I wanted was to help. Cheers.Mon, 15 Nov 2010 15:12:36 GMTAli Bajwahttp://www.sqlservercentral.com/Forums/Topic290724-150-1.aspx[quote][b]Ali Bajwa (11/5/2010)[/b][hr]It is pretty simple to set the date format in SSRS if you know how to. Please follow my blog to resolve your issue: http://alibajwa.blogspot.com/[/quote]Ali, be careful about making comments like this, please. If you have a specific article on your blot, point him to the perma link, but don't say "follow my blog" like this or people will think you're a spam advertiser and you will get banned.In regards to your first statement, saying "if you know how" is a bit rude. He posted on this forum because he didn't know how. In the future please either answer the question directly, ask for more details if you don't know which answer to give him, or point him to specifically helpful articles. This is proper forum ettiquette.Mon, 15 Nov 2010 06:34:18 GMTBrandie Tarvinhttp://www.sqlservercentral.com/Forums/Topic290724-150-1.aspxIt is pretty simple to set the date format in SSRS if you know how to. Please follow my blog to resolve your issue: http://alibajwa.blogspot.com/Fri, 05 Nov 2010 00:02:50 GMTAli Bajwahttp://www.sqlservercentral.com/Forums/Topic290724-150-1.aspxWhich version of SSRS? 2000, 2005, or 2008?Mon, 18 Oct 2010 08:56:10 GMTBrandie Tarvinhttp://www.sqlservercentral.com/Forums/Topic290724-150-1.aspxi need to print date like October 14, 2010Mon, 18 Oct 2010 08:38:37 GMTkhalidlatifhttp://www.sqlservercentral.com/Forums/Topic290724-150-1.aspxIf it is a string object, you need to convert to date first.For example, if dateEx = "2010-18-05" then:Format(CDate(dateEx), "dd/MM/yyyy")Tue, 18 May 2010 08:27:18 GMTjadernethttp://www.sqlservercentral.com/Forums/Topic290724-150-1.aspxI use this for date parameters:[code]Select Right('0' + Cast(Day(dateRange) as Varchar(2)),2) +'/'+ Right('0' + Cast(Month(dateRange)as Varchar(2)),2) + '/'+ cast(Year(dateRange) as char(4)) as label, dateRange as value[/code]Then in Report Parameters Label shows up like 01/04/2010 (which is what the user sees), value is 04/01/2010 (I am in the UK so users want to see dd/mm/yyyy).DateRange here is a smalldatetime value.Thu, 01 Apr 2010 08:29:44 GMTSeth Lynchhttp://www.sqlservercentral.com/Forums/Topic290724-150-1.aspx[quote][b]dssingh17-819020 (2/3/2010)[/b][hr]Use =FormatDateTime(Data Field Name,2) or =Format(Data Field Name,"mm/DD/yyyy").[/quote]No, impossible, cause lowercase 'mm' will give you minutes in stead of monthsits just the mm that would have to be in uppercase and the dd have to be in lowercase=format(datetimefield.value,"MM/dd/yyyy") = 11/20/2010 or in european format =format(datetimefield.value,"dd/MM/yyyy") = 20/11/2010wkr,EddyWed, 03 Feb 2010 08:19:26 GMTVan Heghe Eddyhttp://www.sqlservercentral.com/Forums/Topic290724-150-1.aspxUse =FormatDateTime(Data Field Name,2) or =Format(Data Field Name,"mm/DD/yyyy").Wed, 03 Feb 2010 06:02:02 GMTdssingh17-819020http://www.sqlservercentral.com/Forums/Topic290724-150-1.aspxTry this one. May helps.http://praveenbattula.blogspot.com/2010/01/date-formatting-in-sql-server-reporting.htmlSun, 17 Jan 2010 03:51:41 GMTbattula.praveenhttp://www.sqlservercentral.com/Forums/Topic290724-150-1.aspxRyan,Would not work,cause "mm" stands for minutes, not Monthsif you have the need for the day first :go to the filed expressiontype : =format(fields!fieldname.value,"dd/MM/yyyy") , gives 19/11/2009=format(fields!fieldname.value,"MM/dd/YYYY"), gives 11/19/2009=format(fields!fieldname.value,"yyyy/dd/MM"), gives 2009/19/11you can also change the / by - or : of whatever separator you want to useHopes this helps you a bit.Wkr,EddyFri, 25 Sep 2009 11:58:43 GMTVan Heghe Eddyhttp://www.sqlservercentral.com/Forums/Topic290724-150-1.aspx[quote][b]ryan121 (9/22/2009)[/b][hr]has anyone made a 'cheat sheet' for formatting in SSRS? ...[/quote]Like this perhaps?: [url]http://john-sheehan.com/blog/wp-content/uploads/msnet-formatting-strings.pdf[/url]Thu, 24 Sep 2009 05:33:22 GMTnigel.http://www.sqlservercentral.com/Forums/Topic290724-150-1.aspxhas anyone made a 'cheat sheet' for formatting in SSRS? It would be very helpful as I find myself constantly googling date/time formats...Something like: http://msdn.microsoft.com/en-us/library/73ctwf33.aspx=Format(Fields!startdate.Value, "dd/mm/yy") But refer to url for exact formattingCheers,RyanTue, 22 Sep 2009 18:21:12 GMTryan121http://www.sqlservercentral.com/Forums/Topic290724-150-1.aspxApjchandresh, you're misunderstanding what they're asking for. The format is already MMDDYYYY. They're trying to reverse the day & the month so Day is listed first. Mon, 17 Aug 2009 05:23:14 GMTBrandie Tarvinhttp://www.sqlservercentral.com/Forums/Topic290724-150-1.aspxHi ,you can Used this=Format(Fields!myDate.Value, “MM/dd/yyyy”)Mon, 17 Aug 2009 05:08:20 GMTapjchandreshhttp://www.sqlservercentral.com/Forums/Topic290724-150-1.aspxHi,I could set my format string in the property 'Format' like dd.MM.yyyy and get the correct German date format.RgdsThu, 11 Jun 2009 08:54:34 GMTrene-500237http://www.sqlservercentral.com/Forums/Topic290724-150-1.aspx= right(("0" + Cstr(Day(Fields!admdate.Value))),2) + "/" + right(("0" + Cstr(Month(Fields!admdate.Value))),2) + "/" + Cstr(Year(Fields!admdate.Value))assume your date field name - admdateFri, 21 Nov 2008 09:11:34 GMTdva2007http://www.sqlservercentral.com/Forums/Topic290724-150-1.aspxDoes not make sense but works for me"Printed On " & Format(now,"dd/MM/yy")Fri, 21 Nov 2008 02:42:04 GMTmatt900http://www.sqlservercentral.com/Forums/Topic290724-150-1.aspxThe is a persistent problem and an annoying one that is part of the "America is so big that others will just have to accept our defaults" issues. Others include the constant reversion of Outlook to an American spelling dictionary and printers mysteriously adopting "Letter" rather than A4 paper sizes, no matter how many times you tell them otherwise.I get round this particular issue by always using three-letter month names rather than numbers for the months. This disambiguates the day/month problem, eg: Apr 9 07 is the same as 09 Apr 2007. This always seems to work for data input but the problem is training those pesky users. I use a system that forces them to use three-letter months and will not accept moth numbers so they get used to it in the endKind regardsPaul :)Wed, 09 Apr 2008 11:51:32 GMTPaul Shearinghttp://www.sqlservercentral.com/Forums/Topic290724-150-1.aspxPlease do not post new questions to an existing thread. Post a new thread.Wed, 06 Feb 2008 03:51:39 GMTBrandie Tarvinhttp://www.sqlservercentral.com/Forums/Topic290724-150-1.aspx[quote][b]Jonathan Powell (1/24/2008)[/b][hr]On a slightly different note, in Business Intelligence Design Studio any date parameters seems to want input in MM/DD/YYYY format regardless of the language setting of the report. As my default dates are DD/MM/YYYY this means I have to tweak them everytime I run a report whilst testing it in BIDS. Any ideas?ThanksJonathan[/quote]bump I too get bugged by this problem, Is there any way to resolve? Is annoying entering in us format and all dates in report come out in the format I want (yyyy-mm-dd) grr :hehe:Wed, 06 Feb 2008 03:23:55 GMTnahk.fussuyhttp://www.sqlservercentral.com/Forums/Topic290724-150-1.aspxNilesh,Please start new threads when asking additional questions. I almost answered the original poster when I saw that he had posted back in 2006 and his question was probably not relevant any more.Fri, 25 Jan 2008 06:35:56 GMTBrandie Tarvin