Option Explicit
Dim s As String
Private Sub DTPicker1_Change()
s = CStr(Me.DTPicker1.Year) + "-" + CStr(Me.DTPicker1.Month) + "-" + CStr(Me.DTPicker1.Day)
s = Format(s, Me.DTPicker1.CustomFormat)
Debug.Print s
End Sub
Private Sub Form_Load()
Me.DTPicker1.CustomFormat = "dd-mm"
End Sub