Post reply

DateTime Problems

  • July 14, 2011 at 8:33 am

    #244052

    Hi

    I am trying to convert my report to show datetime in UK date format along with 24hr time e.g. 24/06/2011 17:23.

    I've managed to fix the date by formatting the field in the report, however I can find no way of changing the time to 24 hrs. Here is what I have as my expression for the date

    [font="System"]=FORMAT (Fields!Date_Time.Value, "dd/MM/yyyy")[/font]

    Does anyone know how I could similarly change the time?

    Thanks

  • July 14, 2011 at 8:45 am

    #1352865

    This link has a good chart of all of the Formatting options:

    Take a look at H vs h for 24 vs 12 hour time representation

    jg

  • July 14, 2011 at 8:53 am

    #1352870

    That worked great thanks! Link is extremely helpful

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply