I have a stored procedure that requires a date parameter. It is called from from within an access function. The results from the Immediate window return:
Item not found in this collection.
I am assuming that means there are no records found. In order to eliminate complexities, I have tested the stored procedure form the SQL Server query editor and I am unsure what the correct date format required. Here is the stored procedure or the editor that I am executing from:
This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"!
Step 1: Open a new google tab
Step 2: Go to the left hand upper corn…
With just a little bit of SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form. If you have never written code or looked at an SQL statement before, no problem! ... give i…