I have a below query in one the eventhandlers. All I do in the query is to get all records where Next_Date column is < CurrentDateTime ( I have shown current date below in full date format but it will be variable).
What I am observing is the comparision seems to be failing or not considering time format. For example the below query should not return any records when NEXT_DATE is 9/30/2010 23:59:59 and CurrentDateTime is 9/30/2010 06:22:22. However the query does
return records. It looks like the comparision is just happening with Date and not time. What could be the problem? Please suggest.
<FieldRef Name='Next_x0020_Date' />
<FieldRef Name='Next_x0020_Date' Ascending='False' />
View Complete Post