|
| Need some SQL help in WB19 |
| Iniciado por guest, 02,ene. 2015 23:59 - 1 respuesta |
| |
| | | |
|
| |
| Publicado el 02,enero 2015 - 23:59 |
Hi -
I'm trying to build an SQL query similar to this:
SELECT * FROM HFContact Where bActiveMembershipFlag = 1 AND {the month as a string taken from dDOB} = grpar_Month
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)
dDOB is just a field in the database. I've tried many things and have used the WDSQL tool but to no avail.
Anyone? |
| |
| |
| | | |
|
| | |
| |
| Publicado el 03,enero 2015 - 16:27 |
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...
SELECT * FROM hfcontact WHERE bActiveMembershipFlag = 1 AND WL.DateToString(dDOB,'MMMM') = 'January' |
| |
| |
| | | |
|
| | | | |
| | |
|