Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Apr 2004
    Posts
    76
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Date Time Format (2003)

    We have a table in a SQL database that is on a network drive. There is a time date stamp field in the table that a report references the first 10 characters, which is the date portion only. The problem is some computers see the date for example as 11/07/2006 and some see the date as 11/7/2006 . How do I get all the computers to see it as 11/07/2006?

    Thanks,

    Kent

    Kent

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

    Re: Date Time Format (2003)

    The default format depends on the setting for Short Date in the Regional and Language Settings control panel. If you want a specific format, set the Format property of the text box bound to the date field to <code>mm/dd/yyyy</code>.

  3. #3
    Star Lounger
    Join Date
    Apr 2004
    Posts
    76
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Date Time Format (2003)

    That did the trick! Thanks so much Hans.

    Kent

Posting Permissions

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