Date Format On Sql Server (1 Viewer)

[Allan.Day]

Dear All

I have two table
1. dbo.period (OpeningDate, ClosingDate)
2. dbo.data (blah blah, doc_date)

I want to create a view as follows

Select doc_date from dbo.data
where doc_date> 'select OpeningDate from dbo.period'

both doc_date and opening date have the same format

but the error will still appear as follows:
"Conversion failed when converting date and / or time from character string."

thank you for helping

Allan.Day

 

[Galaxiom]

Select doc_date from dbo.data
where doc_date IN (select OpeningDate from dbo.period)

 

[Allan.Day]

Select doc_date from dbo.data
where doc_date IN (select OpeningDate from dbo.period)

actually the need is between openingdate and closingdate

Doesnt Work :

WHERE doc_date Between IN (SELECT OpeningDate from dbo.PeriodTbl) and IN (SELECT ClosingDate from dbo.PeriodTbl)

 

[Allan.Day]

solved by ()

thanks everyone