Unanswered: Date() Query question (not working properly)
Hi, I use this
to format the date as dd-mmm and am using [Birthday] as the criteria in a query. Birthday is a field with dd-mmm as the format as well.
When I run the query, it only pulls up entries that have 2008 as the year...
Problem is, I didn't even know it was storing the year. When I view the data in the table, it only shows 3-Jan, not 1/3/2008. In the form, however, it does show as 1/3/2008 when I click out of the control.
Any ideas - first as to why it defaults to 1/3/2008 on the form and also to how I can solve this problem. I don't want everyone to store their birthday's as 2008 - plus, I'll have to go back every year and do an update query to update the years to the current year which isn't good.