Skip to Content
May 12, 2016 at 12:51 PM

Rule Logic for missing dates in date range


Hi All,

I am trying to find a logic to get a missing dates from with in a date range.

Here is the scenario: We have a table that has all transactions data with the date column. As per the business process everyday some transactions has to happen and updated to that table with transaction details and with the date. Business wants to capture the date if there is no transactions happened on that day.

I tried writing SQL statement but having difficulty to passing parameter to that.

Below is the date range and need to write a rule to capture missing dates between these range and store in failed database.

Appreciate if some one can help me on this ASAP.




Untitled.png (4.6 kB)