Forum Discussion
Solved
Dynamic datetime parameter using table
I have two tables, Maxdate - which is having single datetime column with one row and Userdate with single datetime column with multiple rows. I have to apply maxdate table as a dynamic parameter ...
MaxDate is a table but you want the value from that table.
Try replacing
[SystemModstamp] <= MaxDate
with
[SystemModstamp] <= MaxDate[MaxDateTime]{0}
This takes the first (index 0) row of the MaxDateTime column of the table.
can you share the file excluding the non sensitive data
https://drive.google.com/file/d/1XLgLpj9FYYXU3EHKHELFjGkzTZjyn9UL/view?usp=drive_link
Please download the report using this link
