pcsoft.us.windevCopyright 2026, PC SOFT29 Jul 2015 21:39:00 Z29 Jul 2015 21:39:00 ZHi - 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) END30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53326-wb19-how-date-valid-sql/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)