Help formating a date.

Clovertech Forums Read Only Archives Cloverleaf Cloverleaf Help formating a date.

  • Creator
    Topic
  • #48567
    Tim Newton
    Participant

      I am new to using Quovadx and I am having a issue with a date field.   After the message runs through the engine it looks like 20060606130000.0000-0500

      Does anyone know how to cut off the .0000-0500?  I would appreciate any help.  Thanks!

    Viewing 3 reply threads
    • Author
      Replies
      • #59017
        Rob Abbott
        Keymaster

          Add a DATECOPYOPT operation to the top of your translation.  Under options, uncheck “Add Precision”.

          Rob Abbott
          Cloverleaf Emeritus

        • #59018
          Anonymous
          Participant

            Rob if I understand correctly. You put this at the top of translation.  It will apply all subsequent transactions in that translation.  What about sub fields within translations?

          • #59019
            Charlie Bursell
            Participant

              John:

              What is says is for Xlate not to be your friend.  The default action is to expand any date timestamp fields to the full 24 bytes as outlined in the HL7 standard.

              If you set precision off in the DATECOPYOPT it tells Xlate to leave those fields alone.  In other words, what comes in is what you get.

              It will apply to any field or sub-field after the DATECOPYOPT.  You can turn it on and off by simply adding more DATECOPYOPT statements.  It will change anything after the statement.

              Hope this makes sense.

              FWIW, since more people want precision off than want it on, in Cloverleaf 5.5 it can default to off saving you from having to put a DATECOPYOPT at the top of every translate.

            • #59020
              Tim Newton
              Participant

                Thanks Rob. That fixed my problem.

            Viewing 3 reply threads
            • The forum ‘Cloverleaf’ is closed to new topics and replies.