date format for formula

L

list

In my tasks I have defined the following formula: DateAdd(21,1,[StartDate]
The format of this formula is a date and is displayed as follows: Day in letters Month/Day/Year in numbers Tim
For example 21 years after July 1, 1980 is displayed as Sun 7/1/2001 12:00 A
I want the display to be July 1, 200
Does anyone know how to change the format?
 
R

Roady [MVP]

The way dates are displayed is control from within Control Panel-> Regional
and Language Options. Here you can change the long and short display format.

--
Roady [MVP] www.sparnaaij.net
Microsoft Office and Microsoft Office related News
Also Outlook FAQ, How To's, Downloads and more...

Tips of the month:
-Setting Permissions on a Mailbox
-Create an Office XP CD slipstreamed with Service Pack 3

-----
list said:
In my tasks I have defined the following formula: DateAdd(21,1,[StartDate])
The format of this formula is a date and is displayed as follows: Day in
letters Month/Day/Year in numbers Time
 
L

List

I already tried changing the format by going into the control panel. My long format for today is May 3. 2004 and my format in outlook for my formula is Mon 5/3/2004 12:00 AM. I want to get rid of the Mon and the 12:00 AM and replace the 5/3/2004 with May 3, 2004. Any other suggestions?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top