Hi Avalor

Another thing you might want to try out, though not 100% sure it will immediately work out: right-click on the top-most node of your web site content, right-click and select 'Manage hostnames'. In the popup window add a new entry, enter a url (e.g. localhost or local.mysite.com and add an entry to the hosts file) and set the langage to Spanish. Re-publish the entire site (by choosing 'Publish' on the node you've just set the node on and select to include children) and go the url you've just added. The .Net UI culture should now be set to es-[XX] and .Net should output the date as defined for that language.

Should that for some reason not work then Jan's solution would be my next go as well.

Cheers,

Sascha

Thanks for your answers!

I've tried the Sascha advice first. Edited my hosts file, added a 'test.com 127.0.0.1' line, then added the hostname in Umbraco, and finally replublished the entire site. But this doesn't seem to work. When I type the url (adding the port, since I'm using WebMatrix + IIS 7.5), for example 'http://test.com:50983' I get this error message:

Bad Request - Invalid Hostname

HTTP Error 400. The request hostname is invalid.

I don't know if this is a dead-end, but meanwhile I'm going to try the Jan's solution.

@Jan, yes, if I change the language for Umbraco UI in the users section I see the UI in spanish, but the website looks the same. I'm trying the FormatDateTime and see what happens!

Ok, I developed a XLST macro to perform the formatting of the string. Here it is (omiting headers), for it might help anyone:

  <xsl:param name="currentPage"/>
  <xsl:param name="dateTime"/>
  <xsl:variable name="dateTimeValue" select="/macro/dateTime" />  <xsl:template match="/">
 <xsl:value-of select="umbraco.library:FormatDateTime($dateTimeValue, 'd')"/>
  </xsl:template>
</xsl:stylesheet>

And then I use the macro in a template like this:

<umbraco:Macro dateTime="[#fecha]" Alias="DateFormat" runat="server"></umbraco:Macro>

And now, I see the date in spanish format: 22/02/2011!!

So, using the macro the problem is solved. But, then I have tried to get the date in english (en-US) format (02/22/11), just to learn how this works, so I have changed the language of the browser to en-US, and the date still appears in spanish locale! I have checked that no hostname is configured in the site and republished the site. Any idea about this?

Thanks again for helping

Hi Avalor

Do you have both spanish and english sites running in the same Umbraco installation, or am I missing something?

If you have an english version you would need to make another macro formatting the date in the english format, since I'm pretty sure that no matter the culture etc. the date will adhere to the formatting made by the macro.

/Jan

Well, my late problem has been solved when I've changed the globalization section in web.config, adding culture="auto" and uiCulture="auto". Now, depending of the language of the browser, the date is formatted in proper way.

In other hand, I have just found that there's no need to use a macro for formatting dates! When inserting an item in a template, you can select the option Format as date: Yes, date only in that dialog!! Shame on me for not seeing it before!!

Anyway, thanks for everything!! (I've marked your comment as an answer, because sure it will be helpful for me in the future)

Hi AValor

And shame on me for not knowing that! :-)

I also learned something from this, so that's really cool!

/Jan

is working on a reply...