Skip to main content
Question

Convert military time

M
Forum|alt.badge.img

I have a date field called 'Date Started' and a text field called 'Time Started' in military format.Based on those two, I'd like to create a new column called 'Date Time Combo' (shown above) in the following format: mm/dd/yyy hh:mm AM/PM.

What's the best method to achieve this?

    3 replies

    danilo_fme
    Evangelist
    Forum|alt.badge.img+45
    • danilo_fmeEvangelist
    • Evangelist
    • November 2, 2018

    Hi @mariofederis

    I simulated here:

     

    Atached the Workspace.

    Workspace_DateTime.fmw

     

    Thanks,

    Danilo

    takashi
    Influencer
    • takashiInfluencer
    • November 3, 2018

    I would recommend you to learn the powerful and flexible FME Date/Time functions in FME 2017.1+.

    Example 1

    Example 2

    takashi
    Influencer
    • takashiInfluencer
    • November 4, 2018
    takashi wrote:

    I would recommend you to learn the powerful and flexible FME Date/Time functions in FME 2017.1+.

    Example 1

    0684Q00000ArLAoQAN.png

    Example 2

    0684Q00000ArL7DQAV.png

    Found another expression that returns date/time string with your desired format.

    @Value(Date Started) @DateTimeFormat(@Format(%04d00,@Value(Time Started)),%l:%M %p)

    0684Q00000ArMHUQA3.png

    Reply


    Helpful Members This Week

    Community Stats

    31,286
    Posts
    118,658
    Replies
    38,873
    Members

    Latest FME

    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings
    A product of
    Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.