>Here is what I want:
>
>if the date is less than current date(), e.g. 1/1/05 it should be 1/1/2005
ROLLOVER only works for whole years. You would have to do your own coding. For example, subtract or add 100 years under certain conditions.
>
>if they type 7/1/05 (e.g. July), it should be 1/1/1905
>
>If they type 7/1/43, it should be 7/1/1943
>
>If they type 7/1/04, it should be 7/1/2004
>
>I guess, I had to write a special code to make it work as I want.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)