0

Field txt to date(dd/mm/yyyy)

There are any script to convert a field txt to a date format (dd/mm/yyyy)

5 replies

null
    • Fred
    • 2 yrs ago
    • Reported - view

    what does the field text data look like? you will need to break up the data into month, day, year and then you can use the date() command to make it a date field.

      • Rafael Sanchis
      • Rafael_Sanchis
      • 2 yrs ago
      • Reported - view

      The Release Date is a text field and need the Format date dd/mm/yyy

      • Rafael Sanchis
      • Rafael_Sanchis
      • 2 yrs ago
      • Reported - view

       

      let firstIndex := index(Release_Date, "/");
let secondIndex := if substr(Release_Date, firstIndex + 2, 1) = "/" then
        firstIndex + 2
    else
        firstIndex + 3
    end;
date(number(substr(Release_Date, secondIndex + 1, 4)), number(substr(Release_Date, 0, firstIndex)), number(substr(Release_Date, firstIndex + 1, secondIndex - firstIndex - 1)))

      I use this formula but the result Wrong

    • Sviluppatore Ninox
    • Fabio
    • 2 yrs ago
    • Reported - view

    Hi  

    Try this:

    let xArray := split(Release_Date, "/");
let xYear := number(item(xArray, 2));
let xMonth := number(item(xArray, 1));
let xDay := number(item(xArray, 0));
date(xYear, xMonth, xDay)

       Fabio

      • Rafael Sanchis
      • Rafael_Sanchis
      • 2 yrs ago
      • Reported - view

       Excelent Fabio thanks a lot.👍

Login to reply

Content aside

  • Status Answered
  • 2 yrs agoLast active
  • 5Replies
  • 144Views
  • 3 Following