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!
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!