Method Community


Day of Week in Grid

Last post 01-04-2016 2:25 PM by Method_Audisho. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 12-22-2015 7:42 AM

    Day of Week in Grid

    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?

  • 01-04-2016 2:25 PM In reply to

    Re: Day of Week in Grid

    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 Sada
    Product Manager
    Toll Free: 1.888.925.6238
    Local & Overseas: 416.847.0400
    Fax: 416.640.6027
Page 1 of 1 (2 items)