Problem with date

[Laura K]

Hi I am making the switch from Access to SQL server and I can not make one
of my queries work. Can you give me some idea on how to do this?

I need to have a countdown from today's date to a future date. I am using
the DateDiff but I am getting a negative number when I need a positive. How
can I switch my negative to positive and vice versa. Of course multiplying
by -1 would work but I have no idea how to add that. I am working in a
view. Is this the way to go?

Here is the SQL

SELECT LauraK.tblTracker.*, DATEDIFF(DAY, CruiseDate, GETDATE()) AS Expr1
FROM LauraK.tblTracker

This gives me that correct DATEDIFF but like I said I need negative to be
positive and positive to be negative.

Any help appreciated
Laura K

 

[Van T. Dinh]

Try

DATEDIFF(DAY, GETDATE(), CruiseDate)

HTH
Van T. Dinh
MVP (Access)

 

[Laura K]

Thanks.

Did it with an absolute value!

Laura

Try

DATEDIFF(DAY, GETDATE(), CruiseDate)

HTH
Van T. Dinh
MVP (Access)

 

[Van T. Dinh]

Absolute values always positive which is not what you asked originally???