Will this statement run, assuming there are no errors in the select and from phrase?

Select $*$ from ART$\_$SHOW where ShowDate $>\text{'}1-$Sep$-2015\text{'}$;