AnsweredAssumed Answered

Interval calculating from approximate dates

Question asked by hopkins on Dec 5, 2011
Latest reply on Dec 7, 2011 by MicheleOlson

I am looking for ideas on how to provide for calculating time intervals from approximate dates. For instance the user knows the exact date some occurance ends but only knows the year it began (or month and year, week month and year, decade, century, quarter and year, etc.). I wanst to return to the user the time interval over which that occurance happened. Obviously, I cannot give the user date fields in which to enter dates, since date fields require complete exact dates. I would have to give the user text fields to accept the dates, then calculate conversions from the text dates to data dates before calculating the interval, which would have to be expressed as an approximate interval unless both dates actually entered were exact. Suggestions welcome.

Outcomes