Date Conversion Query Help 2

[eerich]

I have a text field that I'm trying to convert to dates. The data is stored as mmm-yy, i.e., Jan-08, Dec-07, Nov-07, etc.

In trying to convert this I am not able to get the correct year. My query example is:

Select format(cdate([GLPeriod]), 'mm/yy') as GLP
From myTable;

The results will convert the month correctly, but all of the year values return as '08', e.g., 01/08, 12/08, 11/08.

Any help with how to get the year to be converted correctly?

Thanks

 

[Golom]

Cdate(Left(GLPeriod,3) & "/1/" & Right(GLPeriod,2))

 

[eerich]

Worked perfectly!

Thanks Golom.