|
| WB19 - How to do Date Valid in WL SQL |
| Iniciado por guest, 29,jul. 2015 21:39 - No hay respuesta |
| |
| | | |
|
| |
| Publicado el 29,julio 2015 - 21:39 |
Hi -
My code keeps crashing because there's a few records where there's no date entered into a particular field. I'm trying to use WL.DataValid, But I never get any records back - the query runs, but no records. I know there are birthdays in August present. Anyone have any ideas?
grsdDataSource is Data Source
grsSql is string = [
SELECT
*
FROM
gpsdContact
WHERE
bActiveMembershipFlag = 1
AND
WL.DateValid(dDOB) = 1
AND
WL.DateToString(dDOB,'MMMM') = '%1'
]
grsSql = StringBuild(grsSql,"August")
HExecuteSQLQuery(grsdDataSource,grsSql)
FOR EACH grsdDataSource
Trace(grsdDataSource.dDOB)
END |
| |
| |
| | | |
|
| | | | |
| | |
|