I have a data set that is pulling many different reports into one set. However, I only want to show the data that is from the most recent report.
Is there a way of restricting the data in the script to only show data that is from the most recent REPORT_DATE field? I can't hard code it to the date itself because this gets updated monthly.
I changed the WHERE Exist to WHERE Exists and amended the drop table at the bottom to say Max_Date rather than MAX_DATE, but when it is reloaded, the data remains the same and I see all REPORT_DATE dates 😞