<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0"><channel><category>pcsoft.us.windev</category><copyright>Copyright 2026, PC SOFT</copyright><lastBuildDate>3 Jan 2015 16:27:00 Z</lastBuildDate><pubDate>2 Jan 2015 23:59:00 Z</pubDate><description>Hi -&#13;
&#13;
I'm trying to build an SQL query similar to this:&#13;
&#13;
SELECT * FROM HFContact Where bActiveMembershipFlag = 1 AND {the month as a string taken from dDOB} = grpar_Month&#13;
&#13;
The grpar_Month ('January' or whatever) is fed in as a variable in the Global Declarations of the report (in this case it's a report)&#13;
&#13;
dDOB is just a field in the database. I've tried many things and have used the WDSQL tool but to no avail.&#13;
&#13;
Anyone?</description><ttl>30</ttl><generator>WEBDEV</generator><language>en_US</language><link>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49682-need-some-sql-help-wb19/read.awp</link><title>Need some SQL help in WB19</title><managingEditor>moderateur@pcsoft.fr (El moderador)</managingEditor><webMaster>webmaster@pcsoft.fr (El webmaster)</webMaster><item><author>guest</author><category>pcsoft.us.windev</category><comments>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49682-need-some-sql-help-wb19-49686/read.awp</comments><pubDate>3 Jan 2015 16:27:00 Z</pubDate><description>Found it! Boy that was simple! Which I usually find that it is,, once I can track down the right function and the right syntax..…</description><guid isPermaLink="true">https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49682-need-some-sql-help-wb19-49686/read.awp</guid><link>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49682-need-some-sql-help-wb19-49686/read.awp</link><source url="https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49682-need-some-sql-help-wb19/read.awp">Need some SQL help in WB19</source><title>Re: Need some SQL help in WB19</title></item></channel></rss>
