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

    ExecuteSQL -  return Day Name?


      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):





      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.



      Christopher Bailey


      Certified for FMP 7, 10, 11, 12