I'm pulling data from an Access DB, and one of the fields is date. Here's my query:
select TargetCompany, ID, NextActionDate, NextAction from tblMain
the date is comin up as general format including the 12:00:00AM even though I set the format of this field to ShortDate in Access. I tried using FORMAT(Date, 101) AS Date but it didn't seem to like it. How do I get the date to display without the 12:00:00AM??