>>Thanks. The other reason I choose this because I never have a chance to use Hour(), Minute() or Sec() functions. :)
>>
>>>That is much better, of course...it takes the date settings out of the picture.
>>
>>>>
ltDt = {05/25/2001 5:25:23PM}
>>>>? Datetime(2002, Month(ltDt), Day(ltDt) , Hour(ltDt), Minute(ltDt), Sec(ltDt))
>
>Even more flexable is instead of 2002 hardcode
>use
>
>Year(ltDt)+1
>
It will convert date with year 2000 to 2001 not to 2002 as required.
--sb--