AnsweredAssumed Answered

UFL how can i change format date?

Question asked by Techapat on Dec 12, 2018
Latest reply on Jan 3, 2019 by mhruzik

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")

Outcomes