![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 2 of 2 total |
![]() |
Sun, Oct 21 2007 2:48 PM | Permanent Link |
"Petrus van Breda" | Hi
I need to be able to filter a records according to the following: 1. Have a start date in every record and an end date. 2. Have Years and months in every record. 3. IncMonth(StartDate,((Years*12)+Months)) 4. Convert Date from dd/MM/yyyy to yyyy-MM-dd Now the filter must be when StartDate with all calculations <> EndDate. Is it possible filter record on condition calculations per record? Thanks Petrus |
Mon, Oct 22 2007 4:18 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | Petrus
If you can do it with sql there's a very good chance you can do it with a filter. The other alternatives are to use the OnFilter event (very slow) or write a custom function. My bet would be on the SQL - you just need someone a bit better than me to write it ![]() Roy Lambert |
This web page was last updated on Monday, July 7, 2025 at 06:35 PM | Privacy Policy![]() © 2025 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |