Exporting/Analyzing w/Excel

[Guest]

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!!!

 

[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!!!

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.

 

[Guest]

That works perfect! Thank you!

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!!!

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.