Hello all, could somebody please tell me how to do the above in my code,
i am subtracting two dates and get a - value and would like to remove
the minus. My variable is long.



Best regards,

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***

myVar = Abs(myVar)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Les Stout" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Hello all, could somebody please tell me how to do the above in my code,
> i am subtracting two dates and get a - value and would like to remove
> the minus. My variable is long.
>
>
>
> Best regards,
>
> Les Stout
>
> *** Sent via Developersdex http://www.developersdex.com ***

Just multiply the value by -1 to switch signs:

V = V * -1

To ensure it is always negative, use

V = Abs(V) * -1


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"Les Stout" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Hello all, could somebody please tell me how to do the above in my code,
> i am subtracting two dates and get a - value and would like to remove
> the minus. My variable is long.
>
>
>
> Best regards,
>
> Les Stout
>
> *** Sent via Developersdex http://www.developersdex.com ***

Try

x = -1
x = Abs(x)

Mike

"Les Stout" wrote:

> Hello all, could somebody please tell me how to do the above in my code,
> i am subtracting two dates and get a - value and would like to remove
> the minus. My variable is long.
>
>
>
> Best regards,
>
> Les Stout
>
> *** Sent via Developersdex http://www.developersdex.com ***
>

I have solved it with the following thanks you...

dteDiff = Abs(dteDiff)

Best regards,

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***

Thank you all for the input, much appreciated... :0)

Best regards,

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***