Date formatting

Reply

nickeales Posted: Wed, May 7 2008 8:40 AM

rated by 0 users

How do I set the dateformat correctly to another language? Do I do this on the SQL server, through LCID in the config or somewhere? 

Reply

Alex Crome replied on Wed, May 7 2008 12:34 PM

rated by 0 users

 Have a look at Control Panel > Site Administration > Site Configuration > Setup.  under Basic Site Configuration, there should be a section with DateTime Settings, you should be able to use that to change the format.

Reply

nickeales replied on Wed, May 7 2008 3:56 PM

rated by 0 users

 Yeah I had already noticed how to do that, but it doesn't change the actual language of the date formatting. Its still says "Tuesday" instead of the actual translation.

Reply

Ben Tiedt replied on Fri, May 9 2008 11:48 AM

rated by 0 users

nickeales:

Its still says "Tuesday" instead of the actual translation.

I've logged this feature request as #786.  Updates will be posted to this thread.

Reply

cpaul replied on Fri, May 9 2008 6:54 PM

rated by 0 users

If CS can't localize it globally yet, you might be able to do it yourself by creating a DataControl that extends the relevant data control (e.g. ThreadData, PostData) and overriding the GetPropertyValue method.

        protected override object GetPropertyValue(string property)
        {
            if (!string.IsNullOrEmpty(property) && this.DataSource != null)
            {
                Thread thread = this.DataSource as Thread;
                switch (property.ToLower())
                {
                    //Curse.com Date Ago Specific Format
                    case "localdate":
                        return MyCustomeDateFormat.FormatAgoDate(thread.ThreadDate);
                       
                }
            }

            return base.GetPropertyValue(property);
        }

If you need to localize it to more than one format, you could get the language of the thread (e.g. thread.Section.DefaultLanguage) or the user (CSContext.Current.User.Profile.Language) and format it yourself to the appropriate language.