Hi All,

I'm using Pervasive SQL 7 and I'm looking for a function to parse a date character string from yymmdd into mm/dd/yy. A date field from a table contains date in such format and the application that generates the data (Magic ver. 8.3) doesn't seems able to do the trick.

Thanks,

Ignacio

Is the field in a Btrieve Date format? If so, it's:
YYYYMMDD
stored as a 4 byte number with the first two bytes being the 4 digit year the third byte being the month, and the fourth byte being the day.
How it's coming back from the database and what programming language you're using will determine the best way to manipulate it.