DatePicker Value

[ayionick]

Good day to all!

Just a question about datepicker. I have a datepicker DateFrom and DateTo, I want to output into a textfile the value (e.g. 20063107 to 20060208) of DateFrom and DateTo which the user click/chose. Someone please help. Thanks.

Resolved

[cssriraman]

You need to use format function:

'Example:
Debug.print Format$(now,"YYYYddmm")
Debug.Print Format$(DTPicker1.Value, "YYYYDDMM")