I am new to Oracle. I am trying to create a query in MS Access on linked oracle tables that use a date range like this:
Between FormatDateTime(Now()) And FormatDateTime(DateAdd("yyyy",-2,Now()))
This works as long as I dont connect any other tables and add other parameters in other attached fields.
It took me quite some time to figure out the function above as I understood that oracle handles dates differently.
I need to be able to query oracle tables from MS Access and use dynamic date ranges (as above) and then add parameters to other feilds in linked tables.
What have I missed.
Thanks in advance.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!