>My database is SQL server when I have a SQL date field on my dataentry screen it shows as a date time field. I want it to only show the date, I played with the inputmask and format but I cannot get it to show properly

There're no properties/setting for textbox that would allow only date portion to be visible. Take a look at DateTime File #9666 for a workaround that uses unbound textbox. If you're using remote view, you can change field type to the date in the view.