I have a table where the month field shows as eg.'Nov-07' , however this is a text field
and I want to convert it to a Date/Time field but still have it show as mmm-yy,
does anyone have any suggestions how I can do this? I have tried cDate but this just gives me an error.