Breaking up Date Fields

  • Thread starter Thread starter bomantas
  • Start date Start date
B

bomantas

Hey peeps! I'm wondering if there was a way to break up a date field
into three seperate fields for Month, Day, and Year respectively. I
want to know if there is a way to do this without goign back and
manually reentering dates for thousands of records. Help me pleez!

:confused: :cool: :D :p
 
bomantas said:
*Hey peeps! I'm wondering if there was a way to break up a date
field into three seperate fields for Month, Day, and Year
respectively. I want to know if there is a way to do this without
goign back and manually reentering dates for thousands of records.
Help me pleez!

:confused: :cool: :D :p *
Click to expand...

You could use something like Month([Date]) or Year([Date]) and so
forth, and create a make table query.
 
Could you elaborate a little further. I don't quite understand what you
are trying to say. Right now I have the date in one field, formatted
to be displayed as 12/12/04. I would like to break it up if possible
into three different fields for month, day, then year. :D :D
 
bomantas said:
*Could you elaborate a little further. I don't quite understand what
you are trying to say. Right now I have the date in one field,
formatted to be displayed as 12/12/04. I would like to break it up
if possible into three different fields for month, day, then year.
:D :D *
Click to expand...

You could create a query based on that original table (date field) that
would contain 3 additional columns using the formulas I gave you.

Then you could use that query to create a new table including these 3
fields. Once you are satisfied with the result, you could use that
table as a replacement for your original table.

Now if you don't know what an append or make table query is, I suggest
you get a good Access book before attempting anything.
 
Back
Top