SUBTRACTING DATES AND GETTING POSITIVE RESULTS

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

Guest

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.
 
Try wrapping your formula with Abs( ...) which is the absolute function
which should always make it positive.

Tom
 
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.


Tom Rizzo said:
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.



Mac said:
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.
Click to expand...
Click to expand...
 
Back
Top