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 |