Results 1 to 8 of 8
  1. #1
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    Anaheim, California, USA
    Posts
    560
    Thanks
    17
    Thanked 2 Times in 2 Posts

    Date and Time Entry (2000/SR1)

    I have a pretty simple Form in Word that I would like to enter and display Date and Time in the following formats but still have them be Date and Time fields. I tried setting it up in the forms properties box but it wouldn't let me, or I wasn't doing it right. The format I want to use is:
    Date - 092404
    Time 1354
    No puncuation or anything else. Any idea on how to do it? Thanks.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Date and Time Entry (2000/SR1)

    By Form, do you mean a userform (created in the Visual Basic Editor), or form fields in the document itself created using the Forms toolbar?

  3. #3
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    Anaheim, California, USA
    Posts
    560
    Thanks
    17
    Thanked 2 Times in 2 Posts

    Re: Date and Time Entry (2000/SR1)

    Just a form using the Forms Toolbar. A very simple form at that. Thank you.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Date and Time Entry (2000/SR1)

    I don't think that is possible. Windows doesn't understand MMddyy or hhmm as a format to enter dates/times. But why do you want them to be date and time fields? Do you want to perform calculations with them?

  5. #5
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    Anaheim, California, USA
    Posts
    560
    Thanks
    17
    Thanked 2 Times in 2 Posts

    Re: Date and Time Entry (2000/SR1)

    They don't have to be Date/Time fields. At this time, I don't plan on doing any calculations and can't really foresee doing that in the future. Just figured that since they were date and time, that it would be "better" to have them that way. For this form, I think we may just leave it that way and have the info entered as dd/mm/yyyy and hh:mm. Thanks for your help with this.

  6. #6
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Morden, Surrey, United Kingdom
    Posts
    1,838
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Date and Time Entry (2000/SR1)

    Would entering them as normal dates and having the form format them as you require be sufficient?

    If you format a field to be a date with your MMddyy format and enter a date in a more usual way - "20 Dec 1967", "20/12/67" or even just "20 12 67" - it will convert it to "122067".

    The only thing it won't do is allow you to enter the date as the simple block in the first place.

    Is that any help?
    Beryl M


  7. #7
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Date and Time Entry (2000/SR1)

    Hi Beryl,

    Conversely, you could take a numeric field and reformat its output to a date/time fomat.

    Cheers
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  8. #8
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Date and Time Entry (2000/SR1)

    Hi Beryl:
    Yes, but if you tab into the field again & then try to tab out, it won't let you. You get a message that "a valid date or time is required".

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •