Exract date only

Question & Answer
1

I have a column that contains Dates, numbers, and strings. How I can have a calculated field that extracts only the dates?

1 Like
2

Hi @Sam_Shamsan - Can you please share the sample input and expected output so that it will help in providing the solution.

Regards - Sanjeeb

1 Like
3

Hi @Sam_Shamsan

it depends on how your column is structured, but this can typically be done in two steps:

  1. extract the date part from the string using functions like SPLIT, SUBSTRING, ENDSWIDTH, LOCATE etc.
  2. convert the string into a date using parseDate

Hope it helps,
GL

1 Like