In my details section I have "Ticket.TicketDate (Date)" in the actual database the datatype is a datetime. For the life of me I can't get it to display as a datetime only on this and one other report. I've tried dropping and re-adding the table, Datetime({Field}) as a formula, CDatetime({Field}), all these return the time as 12:00:00:00 instead of pulling the actual time from the database.

I also tried "Verify database" several times to no avail