Method Community

Using Activity for a grid and Due Start Date is there a SQL code that will display the day of week? So it would show the standard Dec-21-2015 but also the day of week?

Hi thesolarguys,

My apologies for the late response. I think the best you can do here is display the number value (1 through 7) for the day of the week using the DATEPART function. Unfortunately, I haven't had any luck getting this to work myself.

If you think this would be useful, I'm happy to do some additional testing to see if I can get it to work. Again, this won't display the day of the week in text format, but instead will display it as a value of 1 through 7 (i.e. Sunday = 1, Monday = 2, etc...). Let me know.

--Audisho