date format for formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
Click to expand...
letters Month/Day/Year in numbers Time
 
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?
 
Back
Top