Date Format Direct Query

I am using a direct query and I cannot use the formatting options for a date.   I am trying to create a report that shows when a unit is supposed to start (DD/MM/YYYY).   However, my data from my...