What kind of date math does 4D’s SQL support? The following gives an error where I’m trying to subtract 2 days from the date:
Select someDate - 2 From someTable The error returned is “Operation VK_TIME - VK_LONG8 is not type safe. Failed to validate SELECT command.” Same thing if you put that kind of date expression in the Where clause. The manual is silent on date math as far as I can tell. ------------------------------------------------ Richard Wright DataDomain [email protected] ------------------------------------------------ ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************

