Re: Displaying dates in dd/mm/yy format

From: George P. (antispam_at_hotmail.com)
Date: 11/30/04 

Date: Tue, 30 Nov 2004 22:26:06 +0200

the short date also contains time information.

You can however format the string to shortformat.

if you want to input dates why don't you use the datetimepicker and format
it to shortdateformat.

"Anonymouse" <Anonymouse@discussions.microsoft.com> wrote in message
news:E21DCC9C-632C-4FC9-B2EB-71D418D16183@microsoft.com...
> I have two Date/Time fields in my Access 2003 database. The VB.NET app I'm
> developing (and making some real progress with) uses TextBoxes to input
these
> as part of a record in a DataSet. Problem: Access always stores years as 4
> digits, and it automatically tags a time onto the field, so when the user
> enters:
>
> 30/11/04
>
> I end up with:
>
> 30/11/2004 00:00:00
>
> when I view the record after it's created; the DataSet is populated using
> the database schema. Since the TextBox is set to display only 8
characters,
> this is annoying at best. The only way I can think of around this is to
store
> the date as a string and write a validation handler for each TextBox that
> inputs dates.
>
> But is there a better way? Can I somehow force Access to store the short
> date and nothing else?
>

Relevant Pages

  • Re: Multiple date formats in a Table
    ... a date field could not store just the year 2004 - it would have ... display it as 1 Jan 2004, or you would have to just display the year for all ... The conversion of your existing text format date should be done in a query, ... Public Function TextToDate(strDate As String) As Date ...
    (microsoft.public.access.tablesdbdesign)
  • Re: PEP proposal optparse
    ... Perhaps it is better to keep descriptions short and store longer ... as doing so ensure readability. ... help="date format string") ...
    (comp.lang.python)
  • Re: Date confusion
    ... Read my reply elsewhere in this string. ... > If you are working with a numeric date and you want the format DDMMYYYY, ... Store the date as a date, and use a format statement to display it how ... since you're relying on Access to coerce the value from ...
    (microsoft.public.access.modulesdaovba)
  • Using Substr and Regular expressions.
    ... I am attempting to take a string similar to the following as input: ... The format of the input will always be of the type ... My Ultimate goal is to be able to create a log file based on the name ... of the input file and store it as a variable to be used later. ...
    (comp.lang.perl.misc)
  • Re: Date format detection
    ... Specifies the locale for which the date string is to be formatted. ... date format for this locale. ... the system default-date format for the specified locale. ... be enclosed within single quotation marks in the date format picture. ...
    (borland.public.delphi.thirdpartytools.general)