I want to get data from the last 14 days to current. I have a view with the following syntax:
SELECT T1.ID,T1.cust_state,T1.Unit_Type,T1.InquiryDate FROM Inquiry T1 WHERE T1.InquiryDate > (.#date - 15) It is very slow and takes a long time to process But if I do: SELECT T1.ID,T1.cust_state,T1.Unit_Type,T1.InquiryDate FROM Inquiry T1 WHERE T1.InquiryDate > 2/10/2018 It opens right away. I know that it is processing row by row when you have the date like (.#date - 15) but is there a way to force it to process like the static. I cannot use variables Dan Goldberg -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
