Log in

View Full Version : How to prevent the time being added in a date field


Wrinks
Nov 23, 2011, 11:30 AM
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!