The effective date is the actual date that the appraiser is on the property, the market value at that specific time. A retrospective appraisal is an appraisal that gives the market value at another specific time other than when the appraisal is done.