Birthday with only Month/Day

akh2010

Registered User.
Local time
Yesterday, 21:31
Joined
Jun 27, 2013
Messages
27
Hello!

I'm trying to create a table with an entry for month/day, no year. I want to create a report that can will sort the birthdays based on month in ascending order. Any suggestions?

I'm currently using the text field to put in, "10/30" or "1/3" but when I try to order the dates, instead of "1,2,3,4,5,6..." I get "1, 10, 11, 12, 2, 3.." etc.

I would appreciate any suggestions! :)

Thanks.
 
Use numerical fields and separate the Month and the Day.
 
How do I get it to say "10/30" etc later on in the query and the report? I tried doing in query BirthDate: [BirthMonth]+"/"+[BirthDay], but that didn't work. I tried [BirthMonth]+"/"+[BirthDay] in the calculated field, but that didn't work either.

Thanks for your response.
 
Use Birthdate: BirthMonth & "/" & BirthDay
 
I tried what you suggested, putting the birth month and dates in separate columns. Then in query, I did the [BirthMonth]&"/"&[BirthDay], and then I sorted it by Ascending, but it still is ordering the birthdays by the first number, i.e. my birthdays are ordered "1, 10, 11, 12, 2, 3, 4" etc. How can I fix this?

Thanks.
 
You did not use Integer fields did you? It is sorting like they are strings.
 
Sorry, I'm not really sure what you mean.

For the fields, I picked "Number" type and put in the numbers. I thought you might have meant the Field Size, so I went and changed it from Long Integer to Integer, but that doesn't appear to be what you're talking about.
 
As RuralGuy said ..

Use Birthdate: BirthMonth & "/" & BirthDay

But sort on BirthMonth first then BirthDay, If you want to hide the fields just remove the tick from the show box of the fields.

Field - Birthdate: BirthMonth & "/" & BirthDay
Sort -
Show - Tick

Field - BirthMonth
Sort - Ascending
Show - No Tick

Field - BirthDay
Sort - Ascending
Show - No Tick
 
I would use a standard date/time field. You can just let the year default to the current year or you can force it to be 1900 or something equally odd. Then the field will behave as a date for purposes of sorting, etc.
 
Thank you for your responses, everyone! Having two separate columns, one for month and day with the hidden sorting works! I really appreciate your answers. :):):):)
 
I think you will find in the long run that the field will work better as a date. You can hide the year. Or if you stick with the two fields, concatenate them with a year to convert to a date to work with them. For example, to find the birthdays two weeks in the future, you'll need to add 14 to the day part and if it's not a date, you'll need to figure out how to adjust the day and month to get the correct value.
 

Users who are viewing this thread

Back
Top Bottom