Current day

[Sl1ver]

Hi
i would like to retreive data from a sql database only for the day its viewed on. Like now i would like all data to be displayed for today,when tomorrow comes, i would like to retreive all data for that day then. Not in a 24 hour period though

[code green]

Why not use a date field entry ans simply match the date?

[Sl1ver]

dit figure it out <= convert(datetim e,convert(varch ar(12),getdate( ))). Thanx for the help tho