pcsoft.us.windevCopyright 2026, PC SOFT24 Apr 2016 00:54:00 Z23 Apr 2016 03:56:00 ZHello All The situation is to find a sell price for a stock item. There is a price contract record attached to a debtor and then stock items are attached to the price contract with prices valid for that contract. The contract has a start and finish date which can be a few months or a year or so. A debtor invoice has a transaction date so when a line on the invoice requests a sell value for a stock item I need to check if there is a current contract for the debtor where the invoice date is between the start and end dates of the contract. At the moment I am using Hfilter() sBrowseKeyItem is string sBrowseKeyItem = HFilter(DSrvCont, "DRCLEUNIK='"+Debtor.DRCLEUNIK+"'"... +" AND StartDate<="+InvoiceDate+""... +" AND EndDate>="+InvoiceDate+""... +" AND ActiveStatus=1") IF HReadFirst(DSrvCont, sBrowseKeyItem) //There is a valid contract //Go and see if there is a stock item match ELSE //There is no contract so get the value another way END //IF HReadFirst(DSrvCont, sBrowseKeyItem) I have also used a query and then tested to see if a record was returned. Both methods work but seem clumsy so I am asking if there is a better way ? Regards Al30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57390-wd20-best-way-find-out-date-between/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57390-wd20-best-way-find-out-date-between-57394/read.awp24 Apr 2016 00:54:00 ZHello Piet Thanks for the idea it got me thinking of other ways. The price contracts are rarely updated so I will look into a…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57390-wd20-best-way-find-out-date-between-57394/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57390-wd20-best-way-find-out-date-between-57394/read.awp[WD20] Best way to find out if a date is between 2 other datesguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57390-wd20-best-way-find-out-date-between-57393/read.awp23 Apr 2016 11:22:00 ZHi Al, In the case that contract periods don't overlap (there can only be one contract in a certain period of time), you can …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57390-wd20-best-way-find-out-date-between-57393/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57390-wd20-best-way-find-out-date-between-57393/read.awp[WD20] Best way to find out if a date is between 2 other dates