Not sure what you wabt Date to look like but try this
format's date as 061407
Format(Date, "[$-409]mmddyy;@")

"TimK" wrote:

I have the following line of code in my add-in.

obj.textbox1.value = format(Date)

I find that the format function often produces inconsistent results, i.e.
sometimes it produces null strings. Anyone know why?