pcsoft.us.windevCopyright 2026, PC SOFT23 Nov 2016 15:55:53 Z22 Nov 2016 21:40:49 ZI can't get HFilter() to work on dates. Here's my code so far. [code:wl] sStart_Date is string = DateToString(tblReminderCards.StartingDate,"YYYYMMDD") sEnd_Date is string = DateToString(tblReminderCards.EndingDate,"YYYYMMDD") sDateRange is string = HFilter(QRY_JobSites,QRY_JobSites.NextService,sStart_Date,sEnd_Date) Info(sStart_Date,sEnd_Date,QRY_JobSites.NextService,sDateRange) HReadFirst(QRY_JobSites,sDateRange) WHILE HOut() = False HReadNext(QRY_JobSites,sDateRange) END HDeactivateFilter(QRY_JobSites) [/code]30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60445-how-use-hfilter-dates/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)fromwebpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60445-how-use-hfilter-dates-60456/read.awp23 Nov 2016 15:55:53 ZHi 1. the datetostrings should not be needed, as a date is STORED as YYYYMMDD by default 2. As you are not telling us wh…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60445-how-use-hfilter-dates-60456/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60445-how-use-hfilter-dates-60456/read.awpHow to Use HFilter on Dates?Sebastian Arnoldpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60445-how-use-hfilter-dates-60450/read.awp23 Nov 2016 11:01:46 ZJustin, seems like you use queries already. So why don't you use parameters in your query? Wouldn't that be more efficient th…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60445-how-use-hfilter-dates-60450/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60445-how-use-hfilter-dates-60450/read.awpHow to Use HFilter on Dates?