I need help limiting the "now()" syntax

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Callan - 07 Oct 2005 10:31 GMT

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

Signature

Callan

Reply to this Message

John.Greenan - 07 Oct 2005 10:51 GMT

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.

Signature

www.alignment-systems.com

> 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

Reply to this Message

Callan - 07 Oct 2005 10:55 GMT

Thanks. That did the trick.
Much Appreciated.

Signature

Callan

> You should wrap up now() in a format call
>
[quoted text clipped - 6 lines]
> > Is this possible? Help would be much appreciated.
> > Many thanks

Reply to this Message

Bob Umlas - 07 Oct 2005 12:04 GMT

Use =TODAY()
Bob Umlas
Excel MVP

> 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

Reply to this Message

Ron Rosenfeld - 07 Oct 2005 14:45 GMT

>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

You could use:

=TODAY()

=INT(NOW())

--ron

Reply to this Message

Robb27 - 19 Sep 2006 09:42 GMT

You can format the cell where the formula is as...Time. - Kills the date and
shows only the time.

> 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

Reply to this Message