Dynamic datetime parameter using table

[BhavyaM]

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 to the datetime column in userdate table

how to get this, waiting for the help 

[Syndicate_Admin]

It works fine when I test something similar on my machine, so I'm not sure what's going wrong.

What exactly did you put in the formula bar?

[Syndicate_Admin · Accepted solution]

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.

[BhavyaM]

thank you so much for the help

[BhavyaM]

Can anyone please help

[BhavyaM]

Hi  @AlexisOlson

Please help

Thanks in advance'

[BhavyaM]

https://drive.google.com/file/d/1XLgLpj9FYYXU3EHKHELFjGkzTZjyn9UL/view?usp=drive_link

[pankaj_lp]

the report has only the max date table 

[BhavyaM]

No Maxdate and Userdate ... Two tables it has... Max date having one row date which I have to convert into parameter and then use it as a dynamic filter in the userdate table

[BhavyaM]

 https://drive.google.com/file/d/1XLgLpj9FYYXU3EHKHELFjGkzTZjyn9UL/view?usp=drive_link

[pankaj_lp]

can you share the file excluding the non sensitive data

[BhavyaM]

https://drive.google.com/file/d/1XLgLpj9FYYXU3EHKHELFjGkzTZjyn9UL/view?usp=drive_link

Please download the report using this link