http://forums.method.me/cs/forums/13.aspxAsk technical support questions, how do I? Questions... Or anything else you want to know from the Method Team and other Method users.enCommunityServer 2007.1 SP2 (Build: 31113.47)http://forums.method.me/cs/forums/thread/31151.aspxMon, 04 Jan 2016 20:25:57 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:31151Method_Audisho0http://forums.method.me/cs/forums/thread/31151.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=13&PostID=31151<p>Hi thesolarguys,</p> <p>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 <span id="mce_3_start" style="overflow:hidden;"></span><span id="mce_4_start" style="overflow:hidden;"></span><a href="https://msdn.microsoft.com/en-us/library/ms174420.aspx" target="_blank">D<span id="mce_2_start" style="overflow:hidden;"></span>ATEPART<span id="mce_3_end" style="overflow:hidden;"><span id="mce_4_end" style="overflow:hidden;"></span></span></a> function. Unfortunately, I haven&#39;t had any luck getting this to work myself.</p> <p>If you think this would be useful, I&#39;m happy to do some additional testing to see if I can get it to work. Again, this won&#39;t display the day of the week in<span id="mce_1_start" style="overflow:hidden;"></span> text format, but instead will display it as <span id="mce_9_start" style="overflow:hidden;">a value of&nbsp;</span>1 through 7 (i.e. Sunday = 1, Monday = 2, etc...). Let me know.</p> <p>--Audisho<span id="mce_8_start" style="overflow:hidden;"><span id="mce_10_start" style="overflow:hidden;"></span></span></p>http://forums.method.me/cs/forums/thread/30087.aspxTue, 22 Dec 2015 13:42:08 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:30087thesolarguys0http://forums.method.me/cs/forums/thread/30087.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=13&PostID=30087<p><span id="mce_0_start" style="overflow:hidden;">Using Activity for a grid and Due Start Date is there a SQL code that will display the day of week?&nbsp;<span id="mce_1_start" style="overflow:hidden;">So it would show the standard&nbsp;<span id="mce_2_start" style="overflow:hidden;">Dec-21-2015 but also the day of week?</span></span></span></p>