Basically from a couple of hours after sunrise to a couple of hours before sunset, assuming you have no cloud cover. Midday (i.e., high noon) is the absolute worst for macro photography, but a few hours to either side is also pretty bad, at least at most latitudes.