How to add as-of date to existing report

Summary

Workforce Management - Worker Assignment Real Time Analysis report

Content

Hi,

I have an existing report that requires an as-of date filter, I'm not sure how to do this as my SQL is limited. OTBI help says the following:

By default only a workers current assignment information as of todays date is retrieved. You can use a SQL prefix SET VARIABLE PARAM_EFFECTIVE_DATE ='@{P_DATE}{2018-12-31}'; (give the correct date format) to reset the default as-of date to report on assignment information in the past or future. This subject area does not report a history of assignment changes. You can use Workforce Management Work Assignment Event Real Time subject area to report a history of assignment changes.