datepicker1.value = date.now().... is not enough if you expect to display date as you wish. I need to use format command so as to display date as you wish. The syntax to display date as 22-May-2008 is:

Format(Now,"dd-mmm-yyyy")

Other problem can happened if your system date is not correct, if so, correct the system date and you may need to replace the system battery also if you are using old Computer.