Date

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

Guest

I have a field in my query is the standard date. I need to break it down into
three different field, Year, Month, Day. Any suggestions?
 
Create a query that uses this table.

In the Field row of the query, in a fresh column, enter:
TheYear: Year([MyDate])
replacing MyDate with the name of your date field.

In the next column, in the field row:
TheMonth: Month([MyDate])
and the next column:
TheDay: Day([MyDate])

The query now shows the 3 parts of the date, and you do not need to store 3
more fields in your table.

In a form or report, you could do this without needing the 3 query fields,
just by setting the Format property of the text box to:
yyyy
m
d
respectively.
 
It works great. Thanks.

Allen Browne said:
Create a query that uses this table.

In the Field row of the query, in a fresh column, enter:
TheYear: Year([MyDate])
replacing MyDate with the name of your date field.

In the next column, in the field row:
TheMonth: Month([MyDate])
and the next column:
TheDay: Day([MyDate])

The query now shows the 3 parts of the date, and you do not need to store 3
more fields in your table.

In a form or report, you could do this without needing the 3 query fields,
just by setting the Format property of the text box to:
yyyy
m
d
respectively.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Robert Smith said:
I have a field in my query is the standard date. I need to break it down
into
three different field, Year, Month, Day. Any suggestions?
Click to expand...
Click to expand...
 
Back
Top