Using a linked table which is an Excel download from a bookings app we use. As the “Time and Date” column was causing issues I created another field using the “Left” command and formatted it “Date”. Whilst my query accepts the date format, when I use” DatePart("w",[date])” and WeekdayName the...