Date format Date format Zbob2 (IS/IT--Management) (OP) 27 Nov 07 19:28 I am trying to export data out of Adapt CRM the date formats are 6 digit numbers for example 732840.I need to convert this to a readable date format.Any Ideas.... RE: Date format mirtheil (Programmer) 27 Nov 07 19:46 You'll need to contact Adapt to find out the way they store dates. They obviously don't use the Btrieve date data type.You might put a series of known dates and try to figure out the method yourself. For example, what date the value 732840 correspond to within Adapt? MirtheilCertified Pervasive DeveloperCertified Pervasive Technicianhttp://www.mirtheil.com RE: Date format Zbob2 (IS/IT--Management) (OP) 28 Nov 07 16:45 I figured it out the date is based on the number of days since year 0000, Once I formated it in excel I realized it was just off by 1900 years.Thank you Don for your help.Bob RE: Date format jbecker614 (TechnicalUser) 5 Dec 07 15:28 I work with an application that uses the same date format. Would any one know of the correct function to use to convert into a date through PSQL. I can do the conversion usind DateSerial after linked to MS SQL or MS Excel, but I was curious to see what the equivalent would be when creating a PSQL view from the Pervasive Control Center.The date format in the application is the number of days since 01/01/0001.