addPriorObservationQuery function

Query to add the number of days of prior observation in the current observation period at a certain date