Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Access (https://www.askmehelpdesk.com/forumdisplay.php?f=441)
-   -   How to prevent the time being added in a date field (https://www.askmehelpdesk.com/showthread.php?t=614315)

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

  • All times are GMT -7. The time now is 10:49 AM.