Hello Mike,

Are you looking for this

Select * from table1
where dateopen = Getdate()

Getdate() though is very specific so maybe this is too granular. If the
data in the colu,m is datetime and is held with only a date and a midnight
time portion then you are probably wanting something like

Select * from table1
where dateopen = CAST(CONVERT(CHAR(8),getdate(),112) AS DATETIME)


Have a look in BOL for the other conversion codes for CONVERT()



Regards

Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com

Allan,

Thank you for your response. I'm using something like this.

select * from matter
where mopendt = convert(char(8), getdate(), 112)

I believe this would help me retrieve data that are only good on the days
that I perform this query.

Michael

"Allan Mitchell" wrote: