Convert text data to text formatted data

3 replies
27 views

Hello

how to convert this text string: "2022-11-12 00:00:00"(Text)

to text string in format "dd/MM/yyyy" ?

Thank you!.

tajinders0001Answer

Inspiring

Hi Vladimir,

Please use the following code to convert the given text string to date time format

a!localVariables(
local!myDate:"2022-11-12 00:00:00",
local!splitDate:fn!split(local!myDate,"-"),
local!splitDay:fn!split(local!splitDate[3]," "),
local!splitTime:fn!split(local!splitDay[2],":"),
local!dateTime:fn!datetime(
local!splitDate[1],local!splitDate[2],local!splitDay[1],
local!splitTime[1],local!splitTime[2],local!splitTime[3]
),
fn!todate(local!dateTime)
)

After that you can either use todate() or text() function for display purposes.

danny.verb

Employee

You can use the text function! In your case, it's best to first convert your string to a date or datetime type. Then do

text(local!myDate, "dd/MM/yyyy")

J

jonesr0001

New Participant

Text function is perfectly consistent. Thank you for the answer! lolbeans