Calculating difference between 2 dates

Question

0.00/5 (No votes)

See more:

Hello all,

I need to calculate the date difference

startdate - Today =15 days

datediff (day,startdate,getdate()) Then

how to get 15 days before date from today

help pl

regards,
Praveena

Posted 25-Jul-11 22:20pm

praveena.karthi

Add a Solution

Comments

Uday P.Singh 26-Jul-11 4:25am

your question is not clear, what are you trying to achieve?

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**Dalek Dave** · Answer 1 · 2011-07-25T22:24:00

Solution 2

This[^] shoul help.

This is the top level of the above link[^]

It is quite comprehensive, should be able to give all you need.

Posted 25-Jul-11 22:24pm

Dalek Dave

Manas Bhardwaj · Answer 2 · 2011-07-25T22:24:00

Solution 1

This is no technical, but logical.

SQL

DECLARE @Today DATETIME, @OldDate DATETIME
SET @Today = GETDATE()
SET @OldDate = @Today - 15
PRINT @OldDate

Posted 25-Jul-11 22:24pm

Manas Bhardwaj

Calculating difference between 2 dates

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Calculating difference between 2 dates

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us