+1-888-365-2779
Try Now
More in this section

Forums / General Discussions / Date Format

Date Format

3 posts, 0 answered
  1. Ivor
    Ivor avatar
    20 posts
    Registered:
    28 Sep 2010
    17 Jan 2011
    Link to this post
    Hi,

    How do I change the date format in the news / blogs so that it displays as ' JAN 17 2011'?

    I have tried inputting MMM dd yyyy into the advanced appearance field 'Dates format' but it displays the date as '52 06 2011'!? which is nonsense!

    What are the date format options?

    Many thanks

    Ben.

     
  2. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    25 Nov 2016
    21 Jan 2011
    Link to this post
    Hi Ivor,

    NewsView and BlogPosts have a control designer from where you can control the data format.

    1. The data format depends on the current culture
    2. The date format depends on the value saved to the database - sf_GCMetaData table.

    SELECT TOP 1000 [ContentID]
          ,[LangID]
          ,[KeyValue]
          ,[Application]
          ,[ValueType]
          ,[ShortText]
          ,[LongText]
          ,[DateTimeValue]
          ,[IntegerValue]
          ,[FloatValue]
          ,[GuidValue]
          ,[Boolean]
          ,[Binary]
          ,[Status]
          ,[CntPrntID]
      FROM [CMSDEV3].[dbo].[sf_GCMetaData]
      WHERE Application = '/Events' OR Application ='/Blogs'
      AND KeyValue='Publication_Date' OR KeyValue = 'Expiration_Date'


    Greetings,
    Ivan Dimitrov
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  3. samuel
    samuel avatar
    5 posts
    Registered:
    01 Nov 2010
    24 Jan 2011
    Link to this post
    Thanks Ivor i got this post helpful for me too.
Register for webinar
3 posts, 0 answered