Well, ok ... in that case, I agree with you. =0)

~~Bonnie


>>Personal preference then I guess. Personally, I think this:
>>

>>lnMonth = CDATE(loRow("Date")).Month
>>

>>is much cleaner and easier to understand than this:
>>

>>Dim ldDate AS Date = Date.Now
>>ldDate = loRow("Date")
>>lnMonth = ldDate.Month
>>

>
>Well, in my case, I also have several others lines such as:
>
>

>lnMonth = ldDate.Month
>lnYear = ldDate.Year
>

>
>So, pulling it from the row and then using it from the variable was a good approach in such circumstance.