5 Replies Latest reply on Jan 3, 2019 9:03 AM by mhruzik

    UFL how can i change format date?

    Techapat

      I would like to change format date.

      Example This data timestamp is "27 June 2017" and i would like to change to "27-Jun-2017"
      My Code

      [FIELD]

      FIELD(1).NAME="PITagName"

      FIELD(1).TYPE="String"

      FIELD(2).NAME="PITagNameTOT"

      FIELD(2).TYPE="String"

      FIELD(3).NAME="PITagNameAVG"

      FIELD(3).TYPE="String"

      FIELD(4).NAME="strTimeStamp"

      FIELD(4).TYPE="String"

      FIELD(5).NAME="PITimeStamp"

      FIELD(5).TYPE="DateTime"

      FIELD(5).FORMAT="dd-MMM-yyyy hh:mm:ss"

       

      strTimeStamp=C10-C22

      PITimeStamp=CONCAT(strTimeStamp," 06:00:00")