AnsweredAssumed Answered

ExecuteSQL -  return Day Name?

Question asked by user10625 on Oct 28, 2013
Latest reply on Oct 28, 2013 by 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

Outcomes