Ms-access – How to format date fields of a Union Query in MS Access

ms-access

I have two tables with date fields. Each table displays the date in Short Date format (MM/DD/YYYY).

I wrote a Union Query to combine these tables, but the Union query displays the date in General Date (long) format (MM/DD/YYYY HH:MM:SS). I would be grateful for a solution to getting dates out of the Union Query in Short Date format.

Best Solution

do a select on the union and format the date column at the end:

select format(foo, "short date")
from (
    blah
union
    blah
)
Related Question