0

Extract year from date field in text format

Hello. I have a date field in text, format DD/MM/YYYY. How can I have an fx-formula field that returns only the year? For today, 15/09/2022, the formula field must return 2022.

With a date field the formula is year(date), but it's not working if the date is from a text field.

Thanks

1 reply

null
    • Paul_Chappell
    • 2 yrs ago
    • Reported - view

    substr(field, 6)

Login to reply

Content aside

  • 2 yrs agoLast active
  • 1Replies
  • 91Views
  • 2 Following