Re: Need a Date Two Ways
- From: John Vinson <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 18 Jan 2007 13:31:25 -0700
On Thu, 18 Jan 2007 11:52:01 -0800, Nanette
<Nanette@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
I have a Start Date whose format in a report needs to be 1/1/07.
When the data is exported into Excel and then imported into another database
the format needs to be a numbered month i.e. "7" in one column and a numbered
year i.e. "07" in another column.
What would be the best design solution???
Store a Date/Time field in your table; set the Format property of the
report textbox to m/d/yy; export to Excel from a Query with two
calculated fields
Month([datefield])
for the numeric month, and
Format([datefield], "yy")
for the text year.
John W. Vinson[MVP]
.
- Prev by Date: Re: Help with Design
- Next by Date: Job efficiency tracking
- Previous by thread: Re: template for Black History Month
- Next by thread: Job efficiency tracking
- Index(es):
Relevant Pages
|
