date format in code

[TUNGANA KURMA RAJU]

if e.offset(1,0)=arrVal(0) then
msg( arrVal(0) & " exists already")
In the above code arrVal(0) is a date I am getting it in message box as
12/5/2005.
I want this as 05-DEC-2005.What additional lines I ahve to insert to get the
result what I need?.

 

[Niek Otten]

msg( Format(arrVal(0),"dd-mmm-yyyy") & " exists already")

 

[TUNGANA KURMA RAJU]

Thanks ,Its working.

msg( Format(arrVal(0),"dd-mmm-yyyy") & " exists already")