Thank you very much Centin. I will use the same approach for week and month.
- Ravi
>*...
>>Instead do this :
>>

>>* Year back
>>thisform.oleControl1.Object.value = dtot(gomonth(date(),-12))
>>* Year forward
>>thisform.oleControl1.Object.value = dtot(gomonth(date(),12))
>>

Cetin
>
>If you would do it based on current value of datetimepicker :
>
>

>* Year back
>with thisform.oleControl1.Object
> .value = dtot(gomonth(ttod(.value),-12))
>endwith
>* Year forward
>with thisform.oleControl1.Object
> .value = dtot(gomonth(ttod(.value),12))
>endwith
>

Cetin