I am trying to create a formula field that will return the Day of the Week concatenated with the date the record was created. The end result should look like this:
Tuesday - 8/13/2019
I have this so far which returns the day of the week the record was created, but I can't seem to concatenate to show just the date after it:
CASE( MOD( DATEVALUE(CreatedDate) - DATE(1900, 1, 7), 7), 0, "Sunday", 1, "Monday", 2, "Tuesday", 3, "Wednesday", 4, "Thursday", 5, "Friday", 6, "Saturday","Error")
I tried the below also, but I get an error saying: Incorrect parameter type for operator '+'. Expected Text, received Date (Related field: Formula)
CASE( MOD( DATEVALUE(CreatedDate) - DATE(1900, 1, 7), 7), 0, "Sunday", 1, "Monday", 2, "Tuesday", 3, "Wednesday", 4, "Thursday", 5, "Friday", 6, "Saturday","Error") + DATEVALUE(CreatedDate)