locked
Converting to military time RRS feed

  • Question

  • Pretty simple, trying to convert to standard to military time.  So, Fields!StartDate, I want to show 10/05/2009  23:00, for example.  I can't seem to find a simple function to do this. 

    Wednesday, August 31, 2011 12:37 PM

Answers

  • Hi vba123,

    Thanks for your question and DJAnsc’s reply. Please also try to use this format function:

    =Format(Fields!StartDate,"MM/dd/yyyy H:mm")

    The effect just like this:

     

    Hope it helps you.

    Thanks,
    Sharp


    Please remember to mark the replies as answers if they help you and unmark them if they provide no help.
    • Proposed as answer by KEROBIN Friday, September 2, 2011 12:36 PM
    • Marked as answer by Sharp Wang Wednesday, September 7, 2011 8:32 AM
    Friday, September 2, 2011 6:27 AM

All replies

  • Hi!

    I assume you mean you want to display a datetime value in military format, correct?  To do this, try: =Format(Fields!StartDate.Value,"MM/dd/yyyy HH:mm:ss")

    The complete list of Format rules can be found here:  http://msdn.microsoft.com/en-us/library/ff768634.aspx

    I hope this helps!


    DJAnsc
    Wednesday, August 31, 2011 9:14 PM
  • Hi vba123,

    Thanks for your question and DJAnsc’s reply. Please also try to use this format function:

    =Format(Fields!StartDate,"MM/dd/yyyy H:mm")

    The effect just like this:

     

    Hope it helps you.

    Thanks,
    Sharp


    Please remember to mark the replies as answers if they help you and unmark them if they provide no help.
    • Proposed as answer by KEROBIN Friday, September 2, 2011 12:36 PM
    • Marked as answer by Sharp Wang Wednesday, September 7, 2011 8:32 AM
    Friday, September 2, 2011 6:27 AM