Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2012
    Posts
    2

    Unanswered: help to format datetime

    guys,

    Need your help to format my date in crystal report.
    my data source is came from SQL server database and i used crystal report to pulled out data. i need the result of my date in crystal report like the format of SQL. when download the file in excel data only the result has a am and pm. thanks in advance.



    SQL Server format =2012-06-21 10:09:26.000 --need this format in CR

    Crystal Report format = 4/3/2009 4:00:00AM


    jov.

  2. #2
    Join Date
    Oct 2013
    Posts
    2
    use ToText function

    e.g. ToText({MyDate}, "dd-MM-yy")

  3. #3
    Join Date
    Oct 2013
    Location
    Poland / USA
    Posts
    5

    Datetime format

    You can right-click the filed with data and then select Format Field option. Then you can select lots of formats.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •