I am fairly good with access/excel/etc. However I am running into a brick wall with a database I query regularly for information. It has date/time fields that are tracked in unix time format (number of seconds from 1/1/1970).
My end goal is for a user to set a start date and end date which will be passed to an access query as variables to return all rows between the start and end date.
Right now my workaround solution is to import all rows and create a separate column using Format and formatting the unix time date/time locally into a short date that I can filter easily on. However, as expected, this is terribly slow as the query has to import all the rows of the external database and then calculate the date/time field locally before display results.
I know there has to be a way to pass the query to the external database, but I just don't know what the syntax is going to be (and once that is figured out how to insert the temp variables into the syntax).