txtDate.value = Format(Date, "dd-mmm-yyyy")
--
Gary's Student


"ernie" wrote:

when i put in this code:

txtDate.value = Date

the output format is:

06/09/06 (mm/dd/yy)

how do i modify the code to get the results in this format:

06-Sep-2006 (dd/mmm/yyyy)