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
    • 1 yr 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
      • 1 yr ago
      • Reported - view

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

      • Rafael Sanchis
      • Rafael_Sanchis
      • 1 yr 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
    • 1 yr 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
      • 1 yr ago
      • Reported - view

       Excelent Fabio thanks a lot.👍

Login to reply

Content aside

Categories

View all topics
  • Status Answered
  • 1 yr agoLast active
  • 5Replies
  • 91Views
  • 3 Following