How to ignore the yy "year" in date sorting?

[stanislav]

How to ignore the year in date sorting?

Normally in VBA (Access) when sorting by date/time data you get the data
sorted 1)yy 2)mm 3)dd like:

dd.03.97
dd.07.98
dd.09.98
dd.04.99
...

Please give me a hint how to get it as follows:

dd.03.97
dd.04.99
dd.07.98
dd.09.98
...

(i.e. ignoring the yy - "year&quot
purpose: sorting the dates like holydays or birthdays etc.


The sorting is invoked in a form from form module by
[Me.orderby = ...] and [SELECT ... ORDER BY ...] instructions.


Thank you for a detailed answer. I`m a very beginner in Access VBA.
Trying to making my database using MSOffice standard help files. )

Stanislav /Touch/

 

[jebry]

Hi!

Try this:

Order By Format(YourDateField, "mmdd&quot

hth
Jeff Bridgham
bridgham@purdue.edu