how do i change the date format in access to be short date?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am new at access and I have to change the date in my paper to be "short
date" and I have no clue what I am doing...this is the last part of my paper
to turn in for college and I am doing it online so there is not much help I
can get other than online.. I already have the table done..but I can retype
it if necessary but I just need to change the date format for that table to
be "short date". Thanks
 
The format of a date field is controlled in the reports, forms, or queries.
The entry is stored in the table as an integer that represents the date.

If you wish to change the way the date displays on a report or form, use the
control's "Format" property and set it to "Short Date". You could also add
an unbound control and put something like the following in it...

=Format([SomeFieldName],"Short Date")
 
Go into the table in design view. Select the row with the date. At the
bottom of the page you will see "format" change the drop down to short date.
Save and view your table.
 
Thanks so much...I got it done now...Thanks

Bryan said:
Go into the table in design view. Select the row with the date. At the
bottom of the page you will see "format" change the drop down to short date.
Save and view your table.
Click to expand...
 
Hello sir
how is posible to change sorting date not based on binery numbers? as you
know, in binery, month will be sort 1, 10, 11, 12, 2, ... 9, how can i change
it? it must be 1,2,3,4,5,6,7,8,9,10,11,12

thanks
yousefi

Rick B said:
The format of a date field is controlled in the reports, forms, or queries.
The entry is stored in the table as an integer that represents the date.

If you wish to change the way the date displays on a report or form, use the
control's "Format" property and set it to "Short Date". You could also add
an unbound control and put something like the following in it...

=Format([SomeFieldName],"Short Date")

--
Rick B



Shana said:
I am new at access and I have to change the date in my paper to be "short
date" and I have no clue what I am doing...this is the last part of my paper
to turn in for college and I am doing it online so there is not much help I
can get other than online.. I already have the table done..but I can retype
it if necessary but I just need to change the date format for that table to
be "short date". Thanks
Click to expand...
Click to expand...
 
It has nothing to do with binary numbers. Format changes whatever is being
formatted into a string, and sorting as a string, 10 is less than 2.

If you need ShortDate for display purposes, you can either sort on an
unformatted version of your date field (you don't have to make it visible in
the query's recordset), or you can format it as yyyy-mm-dd.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


yousefi said:
Hello sir
how is posible to change sorting date not based on binery numbers? as you
know, in binery, month will be sort 1, 10, 11, 12, 2, ... 9, how can i
change
it? it must be 1,2,3,4,5,6,7,8,9,10,11,12

thanks
yousefi

Rick B said:
The format of a date field is controlled in the reports, forms, or
queries.
The entry is stored in the table as an integer that represents the date.

If you wish to change the way the date displays on a report or form, use
the
control's "Format" property and set it to "Short Date". You could also
add
an unbound control and put something like the following in it...

=Format([SomeFieldName],"Short Date")

--
Rick B



Shana said:
I am new at access and I have to change the date in my paper to be
"short
date" and I have no clue what I am doing...this is the last part of my paper
to turn in for college and I am doing it online so there is not much
help I
can get other than online.. I already have the table done..but I can retype
it if necessary but I just need to change the date format for that
table to
be "short date". Thanks
Click to expand...
Click to expand...
Click to expand...
 
Back
Top