Reporting on Publish End Dates on Course or Offering Level
We have a dashboard report with various filters. One includes a dropdown with selection of the various courses. Some of them are not applicable/useable anymore and have a publish end date. So, we want to exclude the courses/offerings that have a publish end date.
However, the only end date we can find in OTBI is the effective end date which is a system date and set in the future. Has anyone got an idea how we can work around this? Or can we find this data elsewhere?