Thread: I need help limiting the "now()" syntax
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Callan Callan is offline
external usenet poster
  
Posts: 7
Default I need help limiting the "now()" syntax
Thanks. That did the trick.
Much Appreciated.
--
Callan


"John.Greenan" wrote:

You should wrap up now() in a format call

ie format(now(),"dd/mm/yy")

returns 07/10/05 for the 7th October 2005 if you are running with English
date settings.


--
www.alignment-systems.com


"Callan" wrote:

Hi. I need the "now()" syntax to only return the date, without the time stamp.
Is this possible? Help would be much appreciated.
Many thanks
--
Callan
Reply With QuoteReply With Quote