Extremely helpful JeremyFriedel .
Helping a customer with a similar request and came across this post.
Below is a snipped example of the SQL code for one of the connections.
SELECT
*
FROM
Table A
to_char(A.Timesheetdate, 'MM/DD/YYYY') >= '04/27/2024'
AND to_char(A.Timesheetdate 'MM/DD/YYYY') <= '05/10/2024'
We need to parameterize the dates (highlighted in bold) so we don’t have to update them manually. The dates need to be changed every week on Friday afternoon. The time period of the date range changes every other week from one week to two weeks depending on the payroll cycle. We do know the rolling dates at the start of the year. Are there any dynamic parameter options available we can leverage? Are there any other solutions approaches?
When we build the data sources, we want to pass the date as parameter values and not hardcode inside SQLs.
