>>>Pretty easy to do in VFP, but how to query sqlserver and pull records with a datetime column value that is an odd day...
>>>
>>
>>

>>WHERE (DATEPART(day, DatetimeColumn) % 2) = 1
>>

>
>
>Thanks! I was playing with DATEPART but hadn't gotten there yet.

Same thing with DAY() function too.

select case when DAY(EventTime)%2 =0 then 1 else 0 end as Even from CommunicationLog