SUBTRACTING DATES AND GETTING POSITIVE RESULTS

[Mac]

Good Morning,

I am so new to using formulas in Outlook Forms its not even funny. I need
to go to the book store and see if I can find Outlook Forms for dummies.

I am trying to subtract 2 dates and get positive results but what tends to
happen is negative.

Example: I have 3 fields - Depart Date; Return Date; and No. of days
requesting.

I have No. of days requesting as a formula which is below.

([Return Date]-[Depart Date]) or even vica versa it always results in a
negative number.

 

[Tom Rizzo [MSFT]]

Try wrapping your formula with Abs( ...) which is the absolute function
which should always make it positive.

Tom

 

[Mac]

Ok not sure how to do that but I have typed abs([Return Date]-[Depart Date])
and still get the same results a negative number.

Try wrapping your formula with Abs( ...) which is the absolute function
which should always make it positive.

Tom

--
Looking for a good book on programming Exchange, Outlook, ADSI and
SharePoint? Check out http://www.microsoft.com/MSPress/books/5517.asp

This posting is provided "AS IS" with no warranties, and confers no rights.

Good Morning,

I am so new to using formulas in Outlook Forms its not even funny. I need
to go to the book store and see if I can find Outlook Forms for dummies.

I am trying to subtract 2 dates and get positive results but what tends to
happen is negative.

Example: I have 3 fields - Depart Date; Return Date; and No. of days
requesting.

I have No. of days requesting as a formula which is below.

([Return Date]-[Depart Date]) or even vica versa it always results in a
negative number.