Date is rendering as a number in excel not a date

3 posts, 1 answers
  1. Janus Pedersen
    Janus Pedersen avatar
    34 posts
    Member since:
    Dec 2008

    Posted 21 Aug 2009 Link to this post

    Hi
    I have a report with a date and when it is translated to a Excel the date is a number.

    14-02-2008 07:31:00 will be 39492,3131944444
    and
    09-07-2008 12:30:00 will be 39638,5208333333
    pls. help my here.

    OS info:
    Win XP
    Telerik version : Q2 2009
    .NET : 3.5
    Lang. DK

    Janus S. Andersen

     
  2. Answer
    Chavdar
    Admin
    Chavdar avatar
    898 posts

    Posted 21 Aug 2009 Link to this post

    Hello Janus Sick Andersen,

    You have to set the Format property of the Textbox item as well. Either put {0:d} or use the Format Builder to select one of the predefined date-time formats.

    Sincerely yours,
    Chavdar
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Check out the tips for optimizing your support resource searches.
  3. DevCraft banner
  4. Janus Pedersen
    Janus Pedersen avatar
    34 posts
    Member since:
    Dec 2008

    Posted 23 Sep 2009 Link to this post

    Thanks it works fine
Back to Top