>Yes, but I like clean code for several reason such as understandability when reading the code.

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

~~Bonnie