2 Replies Latest reply on Oct 28, 2013 11:34 AM by user10625

    ExecuteSQL -  return Day Name?

    user10625

      Hello Everyone,

       

      Anybody know if there is a way, within the context of ExecuteSQL, to convert a Date into a WeekDay Name?

       

      Various tricks I saw by googling do not seem to be implemented by FMP (although it's entirely possible that I mis-dotted an i or mis-crossed a t):

       

      http://stackoverflow.com/questions/4492568/how-to-display-a-day-from-the-date

      http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_weekday

       

      I know there are ways of converting once you get back to FMP-land, but I'm wondering if I can do it before I get there.

       

      Thanks,

      Christopher Bailey

      Baytaflow

      Certified for FMP 7, 10, 11, 12