How to prevent the time being added in a date field
Hi
I'm trying to work out how to prevent the time being added to a date field. Occasionally I've noticed that the time is showing even though all the date fields in the tables I have set up are set to medium date format. All date info is entered through forms.
It's not a major issue but it is causing a few problems with a database I have set up; reports can be printed by a user specified date range and it looks like some of the data is being missed off the reports. Example - print date range is 1st - 10th November; records with the date 10th Nov are all included except those that records where the time is also showing in the date field...
Hope this makes sense... thanks!