software

if e.offset(1,0)=arrVal(0) then
msg( arrVal(0) amp; quot; exists alreadyquot;)
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),quot;dd-mmm-yyyyquot;) amp; quot; exists alreadyquot;)

--
Kind regards,

Niek Otten

quot;TUNGANA KURMA RAJUquot; gt; wrote in
message ...
gt; if e.offset(1,0)=arrVal(0) then
gt; msg( arrVal(0) amp; quot; exists alreadyquot;)
gt; In the above code arrVal(0) is a date I am getting it in message box as
gt; 12/5/2005.
gt; I want this as 05-DEC-2005.What additional lines I ahve to insert to get
gt; the
gt; result what I need?.
Thanks ,Its working.

quot;Niek Ottenquot; wrote:

gt; msg( Format(arrVal(0),quot;dd-mmm-yyyyquot;) amp; quot; exists alreadyquot;)
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;TUNGANA KURMA RAJUquot; gt; wrote in
gt; message ...
gt; gt; if e.offset(1,0)=arrVal(0) then
gt; gt; msg( arrVal(0) amp; quot; exists alreadyquot;)
gt; gt; In the above code arrVal(0) is a date I am getting it in message box as
gt; gt; 12/5/2005.
gt; gt; I want this as 05-DEC-2005.What additional lines I ahve to insert to get
gt; gt; the
gt; gt; result what I need?.
gt;
gt;
gt;