Need to select max period

user12116294

Hello Experts,

Problem description:-

I have a two table Table_A and Table_Time.

Both table has a common column with format MMYYYY.

There is a prompt on this column with period from table_time.

If user select any value from prompt let say 201707 from table_time then both table join on this column period if the data is present, this is ok and data is coming up.

Problem is  let say user select 201707 and the selected period value is not present in Table_A then it should be joined on max available period of Table_A (if value 201704 is present in table_a then it should joined on that value in-spite of user select from 201707 selected).

Can we achieve it please let me know

Thanks for the help and suggestion.

Regards,

AK

Thomas Dodds

LAST() where value <= prompted value