Try ToText(Month ({Emp.DateStarted}), "00") & "/" & ToText(Year({Emp.DateStarted}), 0). The "00" ensures you get 06/2005 rather than 6/2005, which is what you want if you are going to sort using the field.
You could just have formatted your datefield itself to appear as the month and year by going to the format->date->customize tab and selecting Month: 03, Day: None, Year: 1996 (or whatever depending upon your version). The advantage is that it will sort correctly by date and you can work with the datefield as a date.
As in my post of 12:38. To get the year in yy format, you would choose "99". Or maybe I'm missing something about what you mean, Naith? This just changes the display of the date, while leaving it in date format.
That would result in 6/99 as opposed to 06/99. I thought the point was that there should be a leading zero. Maybe I misinterpreted the initial requirement.
O.M.G. I only just woke up and re-read your post. Of course customisation would achieve this. I initially thought you were making reference to selecting one of the preset M/YY formats.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.