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.
Is the field in a Btrieve Date format? If so, it's:
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.
Certified Pervasive Developer
Certified Pervasive Technician
Custom Btrieve/VB development http://www.mirtheil.com
I do not answer questions by email. Please post on the forum.