Date Format in Calculated Field

  • Thread starter Thread starter MT DOJ Help Desk
  • Start date Start date
M

MT DOJ Help Desk

Outlook 2000

I've recently setup an Outlook calendar for our office schedule. I created
a custom view for the calendar, and found that sometimes it was showing the
correct end date for events, and sometimes it wasn't. So I created a custom
field to calculate the correct end date based on the category of the event.
Here is the formula:

IIf([Categories]="On Call",[End],[Recurrence Range End])

This works, but there is one small annoyance. The formula displays the time
as part of the field, and I want it to display just the date. I've played
around with using the Day( ), Date( ), and DateValue( ) functions, but I
still can't get it to display only the date.

Is there a way to modify the above formula so that the results display only
the date portion of the value?

-- Tom

MT DOJ Help Desk

Making the world a safer place.
 
I managed to answer my own question. I had been looking for the right
thing, but I was looking in the wrong place. When I was editing the
calculated field, I looked at the Text functions and I found the Format
function. I re-wrote the formula as follows, and now it displays as I want
it to.

IIf([Categories]="On Call",Format([End],"ddd m/d/yyy"),Format([Recurrence
Range End],"ddd m/d/yyy"))

-- Tom

MT DOJ Help Desk

Making the world a safer place.
 
Back
Top