Adding a colon in between hours and minutes for a time in OpenGate

Home/Support/OpenGate/Adding a colon in between hours and minutes for a time in OpenGate

Home Forums Support OpenGate Adding a colon in between hours and minutes for a time in OpenGate

Viewing 1 post (of 1 total)
  • Author
    Posts
  • Shawn Kenny
    Keymaster
    Post count: 27

    The following will be added to an NPR time field in OpenGate in order to return the time with a colon in between hours and minutes: “0925”^X,X$2_”:”_(X%1)
    so: {@ADM.PAT.admit.time^X,X$2_":"_(X%1)} AS [Admit_Time,5,String]
    Query Ex:
    `Select
    ADM.PAT.name as [Name],
    ADM.PAT.location as [loc],
    ADM.PAT.admit.time as [AdmitTime],
    {@ADM.PAT.admit.time^X,X$2_”:”_(X%1)} AS [Admit_Time,5,String]
    from ADM.PAT.main

Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.

Blue Elm Eventts

December 2018
S M T W T F S
« Aug    
 1
2345678
9101112131415
16171819202122
23242526272829
3031