In VBA you can use Format
Msgbox Format(Date,"mm/dd/yy")

Can you elaborate your requirement when you say "to the a date variable"

If this post helps click Yes
---------------
Jacob Skaria


"JT" wrote:

Is it possible to convert a system date in dd/mm/yy format to the a date
variable in the mm/dd/yy format?


--
JT