Transform date to text

I have a date column with this format yyyy/dd/mm and I want to have another column that reads the day of the week “monday, tuesday, etc”. Just like the excel funtion: (TEXT, CELL, “ddddd”). Thanks!!!

Hi @Ipdod , first if it is a string in that format rather than an actual Date column, you would need to turn it into an actual Date datatype using String to Date&Time, with a format mask of yyyy/d/M (case sensitive)

After that you can use the Extract Date&Time Fields node to pull out Day of week (name).

Alternatively Date&Time to String, specifying just a mask of EEEE should he able to return the day of the week I think.

1 Like

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.