Display date as MM/DD in reports

[papabill]

I have a simple database with a membership list that has birth dates and anniversary dates entered as MM/DD/YYYY, but in the report I want them to display as MM/DD. (Some of our members don't want their ages told <g>)

I have searched for the last couple of days, and can find nothing.

(Actually, I'm not quite sure what phrase I'm supposed to be searching for.)


Thanks

 

[Useful]

Hello!

=TEXT(A1,"mm/dd") - ?

 

[Joe4]

=TEXT(A1,"mm/dd")

Not quite. That is an Excel solution. This is an Access question in the Access Forum.

Try:

Format([MyDateField],"mm/dd")

 

[papabill]

I'm sorry, but I still don't understand how to use this information.

 

[Joe4]

Is your Report based directly on the Table, or on a Query?
My preference is to base all Reports and Forms on Queries instead of Tables. Then you can do most of your calculations in the Query instead of directly on the Report itself (I think it is easier to maintain and make changes if done in a Query).

So this would be a calculated field in your Query:

BirthDate: [COLOR=#333333]Format([MyBirthDateField],"mm/dd")[/COLOR]

Then, you would just put this field on your Report (note, if your Report is based on your Table, you will need to change the Record Source property of your Report to use your new Query instead of your Table).

 

[papabill]

Thanks, I finally got "the little gray cells" working and figured it out. Appreciate the help.

NOW, if I had answers to the other 1000 questions I need answered, I'd be great <g>

 

[papabill]

I've gotten some tips about using SQL, and would love to know how to adapt this to the SQL query.

Here is what I have now in my table:

FName
LName
Birthday

I'd like to show another field as BDay in the m/d format. How would I do that in SQL?

Thanks

 

[Joe4]

What version of SQL Server are you doing this on?

 

[papabill]

I'm working on Window 7, using Microsoft Access 2007

 

[Joe4]

I thought you said you were trying to do this in SQL. I am guessing now you mean "SQL View in Access" (SQL and Access are actually two different database programs, with slightly different syntax).

SQL View in Access just another way to view the query code. So it would be very similar to the answer to the previous question. In SQL View, it would just look like:

[COLOR=#333333]Format([Birthday],"m/d")[/COLOR]