pcsoft.us.windevCopyright 2026, PC SOFT23 Mar 2016 16:45:00 Z23 Mar 2016 16:08:00 ZI have an SQL query with a subselect that uses case statements to return Date and Days. Is there a way to add the Days to the Date and still have a valid Date? The following code is as far as I have gotten. The last line won't work all the time. 20161105 + 30 days = 20161135 instead of 20161205. If I get rid of WL.Val() it appends the two expressions as strings (20161105 + 30 = 2016110530). SELECT * FROM( SELECT ID,CASE WHEN Date3 <> '' THEN Date3 WHEN Date2 <> '' THEN Date2 WHEN Date1 <> '' THEN Date1 ELSE '' END AS Date, CASE WHEN Date3 <> '' THEN Days3 WHEN Date2 <> '' THEN Days2 WHEN Date2 <> '' THEN Days1 ELSE '' END AS Days) FROM Schedule WHERE Date <> '' AND Days <> '') WHERE WL.Val(Date) + WL.Val(Days) > SUBSTRING(SysDate,0,8)30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57001-wd20-sql-add-days-date/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57001-wd20-sql-add-days-date-57003/read.awp23 Mar 2016 16:45:00 ZGood call. WHERE WL.DateDifference(Date,SUBSTRING(SYSDATE,0,8)) > Days Thanks!https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57001-wd20-sql-add-days-date-57003/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57001-wd20-sql-add-days-date-57003/read.awp[WD20] SQL - Add Days to Dateguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57001-wd20-sql-add-days-date-57002/read.awp23 Mar 2016 16:27:00 ZHey Curtis, If you know the number of days, then why not turn your logic around a bit so the result is the difference (in day…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57001-wd20-sql-add-days-date-57002/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57001-wd20-sql-add-days-date-57002/read.awp[WD20] SQL - Add Days to Date