Exporting/Analyzing w/Excel

C

cynteeuh

I have a query that I'd like to export just the "mmm dd" of a date field, but
when I do that, it retains the year.

Is there a way to export just the "mmm dd" and exclude the year?

Thanks in advance for any help!!!
 
F

fredg

I have a query that I'd like to export just the "mmm dd" of a date field, but
when I do that, it retains the year.

Is there a way to export just the "mmm dd" and exclude the year?

Thanks in advance for any help!!!
Click to expand...

Add a new column to the query.
NewField:Format([DateField],"mmm dd")

Use this column instead of the [DateField] in the spreadsheet. It will
no longer be date datatype.
 
C

cynteeuh

That works perfect! Thank you!

fredg said:
I have a query that I'd like to export just the "mmm dd" of a date field, but
when I do that, it retains the year.

Is there a way to export just the "mmm dd" and exclude the year?

Thanks in advance for any help!!!
Click to expand...

Add a new column to the query.
NewField:Format([DateField],"mmm dd")

Use this column instead of the [DateField] in the spreadsheet. It will
no longer be date datatype.
Click to expand...
 
Top