Skip to main content
V
vladimirv0001
December 1, 2021
Solved

Convert text data to text formatted data

  • December 1, 2021
  • 3 replies
  • 0 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!. 

    Best answer by tajinders0001

    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.

    3 replies

    danny.verb
    danny.verb
    December 1, 2021

    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
      December 2, 2021

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

      tajinders0001
      tajinders0001Answer
      December 2, 2021

      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.

        Terms & ConditionsAccessibility statement