Dates and Time are stored as INT in the SQL database. This is different than the normal datetime datatype that is commonly used. A stored procedure is provided with each install of PRM that you can call from your report writer (such as Crystal Reports) to convert the Date and Time to the more common datetime datatype.
To use this in a query replace "PNV_SALESDATE, PNV_TIME" with "dbo.prm_ConvertPRMDateTime(PNV_SALESDATE, PNV_TIME) AS DateTime".
Example:
SELECT PNV_INVOICENO, PNV_POSTED, PNV_TOTAL, dbo.prm_ConvertPRMDateTime(PNV_SALESDATE, PNV_TIME) AS DateTime
FROM PINVOICE
