Reporting on a "As Of" Date - Any Suggestions?

Summary

Trying to leverage an existing data field/derived field to calculate an as of date to report on historical data and get a snapshot of data at a point in time.

Content

I have attempted to use this type of data field in numerous reports such as funnels, open/filled requisitions, openings per recruiter etc. The goal is to be able to get a snapshot in time of X amount of requisitions and/or openings to analyze trends over time. I have gotten close by leveraging pre-existing data items in OBIEE, however, it always seems to affect the correct number of data that should be returned.