Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - ms access general date format problems
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

ms access general date format problems

 Post Reply Post Reply
Author
exo_dus View Drop Down
Newbie
Newbie


Joined: 23 June 2003
Location: Australia
Status: Offline
Points: 7
Post Options Post Options   Thanks (0) Thanks(0)   Quote exo_dus Quote  Post ReplyReply Direct Link To This Post Topic: ms access general date format problems
    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

Back to Top
ljamal View Drop Down
Mod Builder Group
Mod Builder Group


Joined: 16 April 2003
Status: Offline
Points: 888
Post Options Post Options   Thanks (0) Thanks(0)   Quote ljamal Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.