find date difference

Look at how i did and take it from there

DECLARE @StartDate DATETIME

DECLARE @EndDate DATETIME

SET @StartDate ='2010-01-10'

SET @EndDate ='2010-01-15'

SELECT DATEDIFF(day, @StartDate, @EndDate) AS [Days Difference]

Thank you for posting at Dotnetfunda
[Administrator]

Klbaiju, if this helps please login to Mark As Answer. | Alert Moderator

my date format is dd/mm/yyyy
that is the problem

Klbaiju, if this helps please login to Mark As Answer. | Alert Moderator

SELECT DATEDIFF(day, 23/04/2010, 21/04/2010) AS [Days Difference]

this showing error

Klbaiju, if this helps please login to Mark As Answer. | Alert Moderator

What Error are you getting ?

Thank you for posting at Dotnetfunda
[Administrator]

Klbaiju, if this helps please login to Mark As Answer. | Alert Moderator

this is my query

begin


select substring(intourpackagefromtodates,0,dbo.LastIndex(intourpackagefromtodates,'-')) as date1 from tourdetailsnew where vctourcode='bj-456' and intourday='2'
select substring(intourpackagefromtodates,dbo.LastIndex(intourpackagefromtodates,'-')+1,len(intourpackagefromtodates)-(dbo.LastIndex(intourpackagefromtodates,'-'))) as date2 from tourdetailsnew where vctourcode='bj-456' and intourday='2'
select datediff(d,date2,date1)+1 as days
end

error is


Msg 207, Level 16, State 1, Line 7
Invalid column name 'date2'.
Msg 207, Level 16, State 1, Line 7
Invalid column name 'date1'.


select substring(intourpackagefromtodates,0,dbo.LastIndex(intourpackagefromtodates,'-')) as date1 from tourdetailsnew where vctourcode='bj-456' and intourday='2'

this query returns
23/04/2010
select substring(intourpackagefromtodates,dbo.LastIndex(intourpackagefromtodates,'-')+1,len(intourpackagefromtodates)-(dbo.LastIndex(intourpackagefromtodates,'-'))) as date2 from tourdetailsnew where vctourcode='bj-456' and intourday='2'
this return
21/04/2010
if i avoid
select datediff(d,date2,date1)+1 as days

iam struck in section


Regards
K L BAIJU

Klbaiju, if this helps please login to Mark As Answer. | Alert Moderator

if date2 and date1 are variables then it means you need to add @ sign before the name of the variable to be like this
[code]
@date1

or

@date2
[/code]

Thank you for posting at Dotnetfunda

Vuyiswa Maseko

Thank you for posting at Dotnetfunda
[Administrator]

Klbaiju, if this helps please login to Mark As Answer. | Alert Moderator