probably really easy but its foxed me
i have a date field in which a number of records have the date as DateTime and it shows todays date as 4/10/2010 00:00:00
but if i create a query with Getdate() it does not find the above records as getdate() has the time as well i assume
how can i do the query to get the date without the time or at least to 00:00:00
thanks
i have a date field in which a number of records have the date as DateTime and it shows todays date as 4/10/2010 00:00:00
but if i create a query with Getdate() it does not find the above records as getdate() has the time as well i assume
how can i do the query to get the date without the time or at least to 00:00:00
thanks