The problem we encountered is that when we have a datetime field and the date and time parts are use, you can not do a select using only the date part in the where clause. To do so we have to use de datepart function to get each part of the date. In order words, we have to put the datepart function three times in the where clause to check the date.

My question was, is it possible to create a function that will do those three datepart and return the date so i can make my where clause. (Ex. where myfunction(DateField) = '02/24/1999'.

For now we are separating the date part and the time part in two datetime field.

Thanks for your help.