I went into the report generator and corrected the format for the date and time to add a space before am and pm
I a running a report now that goes back one year
I think what you came up with is going to work, I will let you know

thanks gain