Print Page | Close Window

ms access general date format problems

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=4150
Printed Date: 29 March 2026 at 7:36pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: ms access general date format problems
Posted By: exo_dus
Subject: ms access general date format problems
Date Posted: 09 July 2003 at 1:54am

hi there..... i am creating an access database for a schedule of employees work times..... i am using a general date format to calculate the number of hours worked..... but when i try to input data entry as 29/5/03 12:00:00 am on a certain day it just displays a null value..... but if i put 29/5/03 12:00:01 am it works fine.... is there any way to get around this.....

thanx in advance




Replies:
Posted By: ljamal
Date Posted: 09 July 2003 at 8:38am
If You just enter the date without a time, I believe it defaults to 12:00:00 am as the time.

-------------
L. Jamal Walton

http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net