pcsoft.us.windevCopyright 2026, PC SOFT31 Jul 2015 20:08:00 Z30 Jul 2015 08:28:00 ZI need to create a Data Source where the DOB month = a selected month (in alpha)... try as I might, I can't seem to get this to work: grsSql is string = [ SELECT * FROM gpsdContact WHERE bActiveMembershipFlag = 1 AND dDOB > '19000101' AND TO_CHAR(dDOB,MONTH) = '%1' ] (Instead of TO-CHAR, I've also tried WL.DateToString(dDOB,'MMMM') = '%1') grsSql = StringBuild(grsSql,"June") HExecuteSQLQuery(grsdDataSource,grsSql) (The dDOB > '19000101' is to handle case where there is no date in the field) Can anyone tell me where I'm going wrong?30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53330-wb19-create-sql-data-source-dob-particular-month/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53330-wb19-create-sql-data-source-dob-particular-month-53351/read.awp31 Jul 2015 20:08:00 ZThanks Piet - Yep, I tend to do that - make things more complicated - that's inexperience for you! lolhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53330-wb19-create-sql-data-source-dob-particular-month-53351/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53330-wb19-create-sql-data-source-dob-particular-month-53351/read.awpWB19 - Create SQL Data Source on DOB by a particular monthguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53330-wb19-create-sql-data-source-dob-particular-month-53349/read.awp31 Jul 2015 13:17:00 ZHi Joel, You are unnecessarily complicating the query by feeding the query parameter as a human readable month instead of dir…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53330-wb19-create-sql-data-source-dob-particular-month-53349/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53330-wb19-create-sql-data-source-dob-particular-month-53349/read.awpWB19 - Create SQL Data Source on DOB by a particular month