Originally Posted by
Western_Neil
Thanks Arvil. Question on the secondary part, how do flag that from the original case (1)? I’m developing a like for the non null camp so I agree with the zero value.
Essentialy it's same. I only added some example rules which you can apply when you want (i.e. like in case time interval is ... set date as ... and possible error as ...). It is useful to avoid situations where you'll later e.g. wonder, why you entered just this date.
Originally Posted by
Western_Neil
Then again the date math and searches will be off. Math by about 1/2 of the error, and searches if the date ranges are not encompassing the date but with in the error value. Any hints?
For simple search you always can have condition like
Code:
... WHERE YourDate BETWEEN YourDate - PossibleError AND YourDate + PossibleError
When you want to search in specific time interval, it will get trickier - it may be you cant take cases where error diapason for certain date doesn't fully belong into search interval fully into account. Calculating the modifier when you assume even distribution is difficult enough, and I hate the thought to handle e.g. cases with normal distribution.