pcsoft.us.windevCopyright 2026, PC SOFT11 Nov 2015 06:38:00 Z10 Nov 2015 12:07:00 ZHi Anybody know how I can add x number of days to a date field through a query. I want to get something like this SELECT LastServiceDate, LastServiceDate + ServiceInterval from Service The service interval can be between 30 or 360 and I want to get the machines due for a service in this month. I have tried with CAST but you cannot cast a date to an integer and back so there must be some other trick. Thanks in advance. Ericus Steyn30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54885-wb19-sql-and-dates/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54885-wb19-sql-and-dates-54901/read.awp11 Nov 2015 06:38:00 ZHi Ericus, do not use "between" when you the field is datetime . depend on the database server that you using, you may endup …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54885-wb19-sql-and-dates-54901/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54885-wb19-sql-and-dates-54901/read.awp[WB19] SQL and Datesguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54885-wb19-sql-and-dates-54888/read.awp10 Nov 2015 13:44:00 ZHi Ericus, In this case the Piet solutions is the best one but if your db is in HFSQL you can use WLanguage functions in the SQ…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54885-wb19-sql-and-dates-54888/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54885-wb19-sql-and-dates-54888/read.awp[WB19] SQL and Datesguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54885-wb19-sql-and-dates-54887/read.awp10 Nov 2015 13:14:00 ZThanks Piet Will give it a try.https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54885-wb19-sql-and-dates-54887/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54885-wb19-sql-and-dates-54887/read.awp[WB19] SQL and Datesguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54885-wb19-sql-and-dates-54886/read.awp10 Nov 2015 12:20:00 ZHi Ericus, You don't need to add anything in SQL, just use: "SELECT * FROM Service WHERE LastServiceDate BETWEEN '%1' AND '%…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54885-wb19-sql-and-dates-54886/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54885-wb19-sql-and-dates-54886/read.awp[WB19] SQL and Dates