convert a date (Monday of each working week) into a text value

System

This discussion was created from comments split from: How can I convert a date to plain text?.

JKCoombes

Hello!

I am trying to convert a date (Monday of each working week) into a text value in a drop down menu so that it can be used as a sort option for card view and we can easily allocate tasks to reource etc

I have successfully converted the date to text using *"" ... however the text returned is dd/mm/yy - 01/02/23 etc ... and the card view does not recognise the "date order" ( so wc 01/02/23 would be followed by wc 01/03/23 ... rather than 08/02/23).

How can I get either - start the original week dates to be useable as cards ( much like grouping by date in a report - or the text to return yy/mm/dd .... which would solve the issue?

Thank you for any advice!!!

Jason Tarpinian

This formula would convert your date into the format you specified:

=RIGHT(YEAR(Date@row), 2) + "/" + RIGHT("0" + MONTH(Date@row), 2) + "/" + RIGHT("0" + DAY(Date@row), 2)