date format in code

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?.

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

--
Kind regards,

Niek Otten

"TUNGANA KURMA RAJU" <TUNGANAKURMARAJU@discussions.microsoft.com> wrote in
message news:A7ADF743-3B6A-4270-98D1-DB04C24DF1C7@microsoft.com...
> 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?.

Thanks ,Its working.

"Niek Otten" wrote:

> msg( Format(arrVal(0),"dd-mmm-yyyy") & " exists already")
>
> --
> Kind regards,
>
> Niek Otten
>
> "TUNGANA KURMA RAJU" <TUNGANAKURMARAJU@discussions.microsoft.com> wrote in
> message news:A7ADF743-3B6A-4270-98D1-DB04C24DF1C7@microsoft.com...
> > 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?.
>
>
>