I have a field that contains date and time, I would like to use the LEFT
function to trim off the data I do not want, as the output is to be used in a
pivot table (yikes). I am hooked to a FOXPRO database. Any suggestions?

Many thanks!
CJ