>>>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
If it's not broken, fix it until it is.
My Blog