pcsoft.us.windevCopyright 2026, PC SOFT28 May 2016 08:49:00 Z27 May 2016 11:18:00 ZHi, I created table based on a query to display incoming contract renewals for employees. I want to display only contracts that are due in 10 days. How can I do this? And if you have any better suggestions, I would be happy to accept :) Kind Regards, Safaas30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57850-question-about-table-based-query/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57850-question-about-table-based-query-57867/read.awp28 May 2016 08:49:00 ZHi Safaas, in w-language: ldDate is date // default is today ldDate..day -= 10 // calculate 10 days earlier // use thi…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57850-question-about-table-based-query-57867/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57850-question-about-table-based-query-57867/read.awpQuestion about Table based on a queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57850-question-about-table-based-query-57863/read.awp27 May 2016 21:51:00 ZSafaas Just do a bit of programming in Wlanguage example: nDateasint is int // a var for the date as int test is Date/…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57850-question-about-table-based-query-57863/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57850-question-about-table-based-query-57863/read.awpQuestion about Table based on a queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57850-question-about-table-based-query-57854/read.awp27 May 2016 12:54:00 ZHey Safaas, Take a look at this example of SQL with dates - it may help? http://27130.foren.mysnip.de/read.php?27131,590755,…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57850-question-about-table-based-query-57854/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57850-question-about-table-based-query-57854/read.awpQuestion about Table based on a queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57850-question-about-table-based-query-57852/read.awp27 May 2016 12:13:00 ZI have employee who signed contract on 27.05.2015 and contract renewal is on 27.05.2016. I want to create a notice table which …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57850-question-about-table-based-query-57852/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57850-question-about-table-based-query-57852/read.awpQuestion about Table based on a queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57850-question-about-table-based-query-57851/read.awp27 May 2016 11:59:00 ZModify your query ???? so you can select on dates ??https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57850-question-about-table-based-query-57851/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57850-question-about-table-based-query-57851/read.awpQuestion about Table based on a query