Jump to content
The ibi Community has moved to a new platform: Please Sign In and choose Forgot Password to continue

We created metadata for a database and for some reason, the ...


Diana Watkins

Recommended Posts

We created metadata for a database and for some reason, the dates are 2 days off between the actual db table and the metadata.

For example, when you sql the table, the dates that return look like:

ENTRYID ADFACCIDENTDATE

7039 2020-12-08

7040 2020-12-08

7044 2020-12-07

The dates that return in WebFOCUS are:

ENTRYID ADFACCIDENTDATE

7039 2020/12/06

7040 2020/12/06

7044 2020/12/05

The date fields in the metadata table are set up as:

FIELDNAME=ADFACCIDENTDATE, ALIAS=ADFAccidentDate, USAGE=YYMD, ACTUAL=DATE,

MISSING=ON, $

So I am not sure what the issue could be. Usually if it is a format issue, the dates would be just completely wrong instead of consistently a couple of days off.

Any suggestions

Link to comment
Share on other sites

DM_Accident.acx:

SEGNAME=DM_ACCIDENT,

TABLENAME=ShipsDM.dbo.DM_Accident,

CONNECTION=EBECON01,

KEY=ENTRYID, $

FIELD=ENTRYID,

AUTOINCREMENT=YES,

START=1,

INCREMENT=1, $

INDEX_NAME=PK_DM_Accident,

INDEX_UNIQUE=Y,

INDEX_COLUMN=EntryID,

INDEX_ORDER=ASC, $

DV_TEMPLATE=ADFREPORTCLOSEDDATE_YQMD,

BASE=ADFREPORTCLOSEDDATE,

DV_CAPTION=ADFREPORTCLOSEDDATE,Simple,

COMPONENTS=ADFREPORTCLOSEDDATE_YEAR/ADFREPORTCLOSEDDATE_QUARTER/ADFREPORTCLOSEDDATE_MONTH/ADFREPORTCLOSEDDATE_DAY, $

DV_TEMPLATE=ADFREPORTCLOSEDDATE_Y_YQMD,

BASE=ADFREPORTCLOSEDDATE,

DV_CAPTION=ADFREPORTCLOSEDDATE,Compound,

COMPONENTS=ADFREPORTCLOSEDDATE_YEAR_Y/ADFREPORTCLOSEDDATE_YEAR_Q/ADFREPORTCLOSEDDATE_YEAR_M/ADFREPORTCLOSEDDATE_YEAR_D, $

DV_TEMPLATE=ADFDRIVERDOB_YQMD,

BASE=ADFDRIVERDOB,

DV_CAPTION=ADFDRIVERDOB,Simple,

COMPONENTS=ADFDRIVERDOB_YEAR/ADFDRIVERDOB_QUARTER/ADFDRIVERDOB_MONTH/ADFDRIVERDOB_DAY, $

DV_TEMPLATE=ADFDRIVERDOB_Y_YQMD,

BASE=ADFDRIVERDOB,

DV_CAPTION=ADFDRIVERDOB,Compound,

COMPONENTS=ADFDRIVERDOB_YEAR_Y/ADFDRIVERDOB_YEAR_Q/ADFDRIVERDOB_YEAR_M/ADFDRIVERDOB_YEAR_D, $

DV_TEMPLATE=ADFDRIVERSTARTDATE_YQMD,

BASE=ADFDRIVERSTARTDATE,

DV_CAPTION=ADFDRIVERSTARTDATE,Simple,

COMPONENTS=ADFDRIVERSTARTDATE_YEAR/ADFDRIVERSTARTDATE_QUARTER/ADFDRIVERSTARTDATE_MONTH/ADFDRIVERSTARTDATE_DAY, $

DV_TEMPLATE=ADFDRIVERSTARTDATE_Y_YQMD,

BASE=ADFDRIVERSTARTDATE,

DV_CAPTION=ADFDRIVERSTARTDATE,Compound,

COMPONENTS=ADFDRIVERSTARTDATE_YEAR_Y/ADFDRIVERSTARTDATE_YEAR_Q/ADFDRIVERSTARTDATE_YEAR_M/ADFDRIVERSTARTDATE_YEAR_D, $

DV_TEMPLATE=DTDATECOMPLETED_YQMD,

BASE=DTDATECOMPLETED,

DV_CAPTION=DTDATECOMPLETED,Simple,

COMPONENTS=DTDATECOMPLETED_YEAR/DTDATECOMPLETED_QUARTER/DTDATECOMPLETED_MONTH/DTDATECOMPLETED_DAY, $

DV_TEMPLATE=DTDATECOMPLETED_Y_YQMD,

BASE=DTDATECOMPLETED,

DV_CAPTION=DTDATECOMPLETED,Compound,

COMPONENTS=DTDATECOMPLETED_YEAR_Y/DTDATECOMPLETED_YEAR_Q/DTDATECOMPLETED_YEAR_M/DTDATECOMPLETED_YEAR_D, $

DV_TEMPLATE=ADFTEMPBDAY_YQMD,

BASE=ADFTEMPBDAY,

DV_CAPTION=ADFTEMPBDAY,Simple,

COMPONENTS=ADFTEMPBDAY_YEAR/ADFTEMPBDAY_QUARTER/ADFTEMPBDAY_MONTH/ADFTEMPBDAY_DAY, $

DV_TEMPLATE=ADFTEMPBDAY_Y_YQMD,

BASE=ADFTEMPBDAY,

DV_CAPTION=ADFTEMPBDAY,Compound,

COMPONENTS=ADFTEMPBDAY_YEAR_Y/ADFTEMPBDAY_YEAR_Q/ADFTEMPBDAY_YEAR_M/ADFTEMPBDAY_YEAR_D, $

DV_TEMPLATE=ADFACCIDENTDATE_YQMD,

BASE=ADFACCIDENTDATE,

DV_CAPTION=ADFACCIDENTDATE,Simple,

COMPONENTS=ADFACCIDENTDATE_YEAR/ADFACCIDENTDATE_QUARTER/ADFACCIDENTDATE_MONTH/ADFACCIDENTDATE_DAY, $

DV_TEMPLATE=ADFACCIDENTDATE_Y_YQMD,

BASE=ADFACCIDENTDATE,

DV_CAPTION=ADFACCIDENTDATE,Compound,

COMPONENTS=ADFACCIDENTDATE_YEAR_Y/ADFACCIDENTDATE_YEAR_Q/ADFACCIDENTDATE_YEAR_M/ADFACCIDENTDATE_YEAR_D, $

DV_TEMPLATE=ADFCURRENTDATE_YQMD,

BASE=ADFCURRENTDATE,

DV_CAPTION=ADFCURRENTDATE,Simple,

COMPONENTS=ADFCURRENTDATE_YEAR/ADFCURRENTDATE_QUARTER/ADFCURRENTDATE_MONTH/ADFCURRENTDATE_DAY, $

DV_TEMPLATE=ADFCURRENTDATE_Y_YQMD,

BASE=ADFCURRENTDATE,

DV_CAPTION=ADFCURRENTDATE,Compound,

COMPONENTS=ADFCURRENTDATE_YEAR_Y/ADFCURRENTDATE_YEAR_Q/ADFCURRENTDATE_YEAR_M/ADFCURRENTDATE_YEAR_D, $

DV_TEMPLATE=ADFDATENOTIFIED_YQMD,

BASE=ADFDATENOTIFIED,

DV_CAPTION=ADFDATENOTIFIED,Simple,

COMPONENTS=ADFDATENOTIFIED_YEAR/ADFDATENOTIFIED_QUARTER/ADFDATENOTIFIED_MONTH/ADFDATENOTIFIED_DAY, $

DV_TEMPLATE=ADFDATENOTIFIED_Y_YQMD,

BASE=ADFDATENOTIFIED,

DV_CAPTION=ADFDATENOTIFIED,Compound,

COMPONENTS=ADFDATENOTIFIED_YEAR_Y/ADFDATENOTIFIED_YEAR_Q/ADFDATENOTIFIED_YEAR_M/ADFDATENOTIFIED_YEAR_D, $

DV_TEMPLATE=DASDATE_YQMD,

BASE=DASDATE,

DV_CAPTION=DASDATE,Simple,

COMPONENTS=DASDATE_YEAR/DASDATE_QUARTER/DASDATE_MONTH/DASDATE_DAY, $

DV_TEMPLATE=DASDATE_Y_YQMD,

BASE=DASDATE,

DV_CAPTION=DASDATE,Compound,

COMPONENTS=DASDATE_YEAR_Y/DASDATE_YEAR_Q/DASDATE_YEAR_M/DASDATE_YEAR_D, $

DV_TEMPLATE=ACEACCIDENTDATE_YQMD,

BASE=ACEACCIDENTDATE,

DV_CAPTION=ACEACCIDENTDATE,Simple,

COMPONENTS=ACEACCIDENTDATE_YEAR/ACEACCIDENTDATE_QUARTER/ACEACCIDENTDATE_MONTH/ACEACCIDENTDATE_DAY, $

DV_TEMPLATE=ACEACCIDENTDATE_Y_YQMD,

BASE=ACEACCIDENTDATE,

DV_CAPTION=ACEACCIDENTDATE,Compound,

COMPONENTS=ACEACCIDENTDATE_YEAR_Y/ACEACCIDENTDATE_YEAR_Q/ACEACCIDENTDATE_YEAR_M/ACEACCIDENTDATE_YEAR_D, $

DV_TEMPLATE=SELFPAIDSTATUS_YQMD,

BASE=SELFPAIDSTATUS,

DV_CAPTION=SELFPAIDSTATUS,Simple,

COMPONENTS=SELFPAIDSTATUS_YEAR/SELFPAIDSTATUS_QUARTER/SELFPAIDSTATUS_MONTH/SELFPAIDSTATUS_DAY, $

DV_TEMPLATE=SELFPAIDSTATUS_Y_YQMD,

BASE=SELFPAIDSTATUS,

DV_CAPTION=SELFPAIDSTATUS,Compound,

COMPONENTS=SELFPAIDSTATUS_YEAR_Y/SELFPAIDSTATUS_YEAR_Q/SELFPAIDSTATUS_YEAR_M/SELFPAIDSTATUS_YEAR_D, $

DV_TEMPLATE=DAAPPEALSIGDATA_DT_YQMD,

BASE=DAAPPEALSIGDATA_DT,

DV_CAPTION=DAAPPEALSIGDATA_DT,Simple,

COMPONENTS=DAAPPEALSIGDATA_DT_YEAR/DAAPPEALSIGDATA_DT_QUARTER/DAAPPEALSIGDATA_DT_MONTH/DAAPPEALSIGDATA_DT_DAY, $

DV_TEMPLATE=DAAPPEALSIGDATA_DT_Y_YQMD,

BASE=DAAPPEALSIGDATA_DT,

DV_CAPTION=DAAPPEALSIGDATA_DT,Compound,

COMPONENTS=DAAPPEALSIGDATA_DT_YEAR_Y/DAAPPEALSIGDATA_DT_YEAR_Q/DAAPPEALSIGDATA_DT_YEAR_M/DAAPPEALSIGDATA_DT_YEAR_D, $

DV_TEMPLATE=CITATIONDT_YQMD,

BASE=CITATIONDT,

DV_CAPTION=CITATIONDT,Simple,

COMPONENTS=CITATIONDT_YEAR/CITATIONDT_QUARTER/CITATIONDT_MONTH/CITATIONDT_DAY, $

DV_TEMPLATE=CITATIONDT_Y_YQMD,

BASE=CITATIONDT,

DV_CAPTION=CITATIONDT,Compound,

COMPONENTS=CITATIONDT_YEAR_Y/CITATIONDT_YEAR_Q/CITATIONDT_YEAR_M/CITATIONDT_YEAR_D, $

DV_TEMPLATE=DTENTERED_YQMD,

BASE=DTENTERED,

DV_CAPTION=DTENTERED,Simple,

COMPONENTS=DTENTERED_YEAR/DTENTERED_QUARTER/DTENTERED_MONTH/DTENTERED_DAY, $

DV_TEMPLATE=DTENTERED_Y_YQMD,

BASE=DTENTERED,

DV_CAPTION=DTENTERED,Compound,

COMPONENTS=DTENTERED_YEAR_Y/DTENTERED_YEAR_Q/DTENTERED_YEAR_M/DTENTERED_YEAR_D, $

Link to comment
Share on other sites

DM_ACCIDENT.mas:

FILENAME=DM_ACCIDENT, SUFFIX=SQLMSS , $

SEGMENT=DM_ACCIDENT, SEGTYPE=S0, $

FIELDNAME=ENTRYID, ALIAS=EntryID, USAGE=I11, ACTUAL=I4, FIELDTYPE=R, $

FIELDNAME=USERID, ALIAS=UserID, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=DRIVERID, ALIAS=DriverID, USAGE=I11, ACTUAL=I4,

MISSING=ON, $

FIELDNAME=DRIVERCODE, ALIAS=DriverCode, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=VALID, ALIAS=Valid, USAGE=I11, ACTUAL=I4, $

FIELDNAME=ADFDOTREPORTABLE, ALIAS=ADFDOTReportable, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFACCIDENTNUM, ALIAS=ADFAccidentNum, USAGE=A200V, ACTUAL=A200V, $

FIELDNAME=ADFINSURANCEFILENUM, ALIAS=ADFInsuranceFileNum, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFPHOTOSRECEIVED, ALIAS=ADFPhotosReceived, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFREPORTSENTTONONTRUCK, ALIAS=ADFReportSentToNonTruck, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFREPORTSENT, ALIAS=ADFReportSent, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFSENDTONONTRUCKING, ALIAS=ADFSendToNonTrucking, USAGE=I11, ACTUAL=I4, $

FIELDNAME=ADFNOPHOTOS, ALIAS=ADFNoPhotos, USAGE=I11, ACTUAL=I4, $

FIELDNAME=ADFNOSTATEMENT, ALIAS=ADFNoStatement, USAGE=I11, ACTUAL=I4, $

FIELDNAME=ADFREPORTCLOSED, ALIAS=ADFReportClosed, USAGE=I11, ACTUAL=I4, $

FIELDNAME=ADFREPORTCLOSEDDATE, ALIAS=ADFReportClosedDate, USAGE=HYYMDs, ACTUAL=HYYMDs,

MISSING=ON, $

FIELDNAME=ADFREPORTCLOSEDBY, ALIAS=ADFReportClosedBy, USAGE=A200V, ACTUAL=A200V, $

FIELDNAME=ADFREPORTFINAL, ALIAS=ADFReportFinal, USAGE=I11, ACTUAL=I4, $

FIELDNAME=ADFSETUPDEDUCTIBLE, ALIAS=ADFSetUpDeductible, USAGE=I11, ACTUAL=I4, $

FIELDNAME=ADFSENDTOINSURANCE, ALIAS=ADFSendToInsurance, USAGE=I11, ACTUAL=I4, $

FIELDNAME=ADFHOLDOPEN, ALIAS=ADFHoldOpen, USAGE=I11, ACTUAL=I4, $

FIELDNAME=ADFUNKNOWNCAUSE, ALIAS=ADFUnknownCause, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFCOSTCOMPLETE, ALIAS=ADFCostComplete, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFDOCSRECEIVED, ALIAS=ADFDocsReceived, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFRELATIONSHIP, ALIAS=ADFRelationship, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFDRIVERADDRESS, ALIAS=ADFDriverAddress, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFDRIVERCELLPHONE, ALIAS=ADFDriverCellPhone, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFDRIVERCITY, ALIAS=ADFDriverCity, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFDRIVERDOB, ALIAS=ADFDriverDOB, USAGE=YYMD, ACTUAL=DATE,

MISSING=ON, $

FIELDNAME=ADFDRIVERHOMEPHONE, ALIAS=ADFDriverHomePhone, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFDRIVERSTARTDATE, ALIAS=ADFDriverStartDate, USAGE=HYYMDs, ACTUAL=HYYMDs,

MISSING=ON, $

FIELDNAME=ADFDRIVERSTATE, ALIAS=ADFDriverState, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFDRIVERSTATEMENTRECEIVED, ALIAS=ADFDriverStatementReceived, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFDRIVERPASSENGER, ALIAS=ADFDriverPassenger, USAGE=A100V, ACTUAL=A100V, $

FIELDNAME=ADFDRIVERPASSENGERPHONE, ALIAS=ADFDriverPassengerPhone, USAGE=A100V, ACTUAL=A100V, $

FIELDNAME=ADFDRIVERZIP, ALIAS=ADFDriverZip, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFDRIVERTYPE, ALIAS=ADFDriverType, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFDRIVERTERMINAL, ALIAS=ADFDriverTerminal, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFDRIVERDIVISION, ALIAS=ADFDriverDivision, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFDRIVERMANAGER, ALIAS=ADFDriverManager, USAGE=A200V, ACTUAL=A200V, $

FIELDNAME=ADFDRIVERFLEET, ALIAS=ADFDriverFleet, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFDRIVERFLEETMANAGER, ALIAS=ADFDriverFleetManager, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFFUELSPILL, ALIAS=ADFFuelSpill, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFHAZMATCHECK, ALIAS=ADFHazMatCheck, USAGE=I11, ACTUAL=I4, $

FIELDNAME=ADFHAZMATSPILL, ALIAS=ADFHazMatSpill, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFHAZMATFILENUM, ALIAS=ADFHazMatFileNum, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFDRIVERFULLNAME, ALIAS=ADFDriverFullName, USAGE=A150V, ACTUAL=A150V, $

FIELDNAME=ADFTIMENOTIFIED, ALIAS=ADFTimeNotified, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFPREVSTATUS, ALIAS=ADFPrevStatus, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFVEHDMG, ALIAS=ADFVehDmg, USAGE=I11, ACTUAL=I4, $

FIELDNAME=ADFPROPDMG, ALIAS=ADFPropDmg, USAGE=I11, ACTUAL=I4, $

FIELDNAME=ADFLOCATION, ALIAS=ADFLocation, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=DTCLINICADDRESS, ALIAS=DTClinicAddress, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=DTCLINICPHONE, ALIAS=DTClinicPhone, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=DTCOMPANYCONTACTED, ALIAS=DTCompanyContacted, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=DTDATECOMPLETED, ALIAS=DTDateCompleted, USAGE=YYMD, ACTUAL=DATE,

MISSING=ON, $

FIELDNAME=DTGENERALNOTES, ALIAS=DTGeneralNotes, USAGE=A1000V, ACTUAL=A1000V, $

FIELDNAME=TRIPNUM, ALIAS=TripNum, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=TRUCKNUM, ALIAS=TruckNum, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFTEMPBDAY, ALIAS=ADFTempBDay, USAGE=YYMD, ACTUAL=DATE,

MISSING=ON, $

FIELDNAME=ADFACCIDENTDATE, ALIAS=ADFAccidentDate, USAGE=YYMD, ACTUAL=DATE,

MISSING=ON, $

FIELDNAME=ADFACCIDENTTIME, ALIAS=ADFAccidentTime, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFACCIDENTTIMEAMPM, ALIAS=ADFAccidentTimeAMPM, USAGE=A10V, ACTUAL=A10V, $

FIELDNAME=ADFACCIDENTTIMECALC, ALIAS=ADFAccidentTimeCalc, USAGE=HHISsm, ACTUAL=HHISsm,

MISSING=ON, $

FIELDNAME=ADFACCIDENTWEEKDAY, ALIAS=ADFAccidentWeekday, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFCURRENTDATE, ALIAS=ADFCurrentDate, USAGE=YYMD, ACTUAL=DATE,

MISSING=ON, $

FIELDNAME=ADFDATENOTIFIED, ALIAS=ADFDateNotified, USAGE=YYMD, ACTUAL=DATE,

MISSING=ON, $

FIELDNAME=ADFLOCATIONCODE, ALIAS=ADFLocationCode, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFLOCATIONOFACCIDENT, ALIAS=ADFLocationOfAccident, USAGE=A200V, ACTUAL=A200V, $

FIELDNAME=ADFLOCATIONNAME, ALIAS=ADFLocationName, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFLOCATIONPHONE, ALIAS=ADFLocationPhone, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFPERSONREPORTING, ALIAS=ADFPersonReporting, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFINSUREDLOCADDY, ALIAS=ADFInsuredLocAddy, USAGE=A200V, ACTUAL=A200V, $

FIELDNAME=ADFACCIDENTADDRESS, ALIAS=ADFAccidentAddress, USAGE=A200V, ACTUAL=A200V, $

FIELDNAME=ADFACCIDENTCITY, ALIAS=ADFAccidentCity, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFACCIDENTSTATE, ALIAS=ADFAccidentState, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFACCIDENTZIP, ALIAS=ADFAccidentZip, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFAUTHORITIES, ALIAS=ADFAuthorities, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFREPORTNUM, ALIAS=ADFReportNum, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFOFFICERSNAME, ALIAS=ADFOfficersName, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFPOLICEPHONE, ALIAS=ADFPolicePhone, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFVIOLATIONSGIVEN, ALIAS=ADFViolationsGiven, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFNOCITATIONS, ALIAS=ADFNoCitations, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFCITATIONTYPE, ALIAS=ADFCitationType, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFDESCRIPTION, ALIAS=ADFDescription, USAGE=TX50, ACTUAL=TX, $

FIELDNAME=ADFCLEANUP, ALIAS=ADFCleanup, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFCLEANUPPHONE, ALIAS=ADFCleanupPhone, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFCOMPANYVEHICLEYEAR, ALIAS=ADFCompanyVehicleYear, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFCOMPANYVEHICLETOWED, ALIAS=ADFCompanyVehicleTowed, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFCOMPANYVEHICLEMAKE, ALIAS=ADFCompanyVehicleMake, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFCOMPANYVEHICLEMODEL, ALIAS=ADFCompanyVehicleModel, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFCOMPANYVEHICLEOWNER, ALIAS=ADFCompanyVehicleOwner, USAGE=A200V, ACTUAL=A200V, $

FIELDNAME=ADFCOMPANYVEHICLESTATE, ALIAS=ADFCompanyVehicleState, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFCOMPANYVEHICLEPLATE, ALIAS=ADFCompanyVehiclePlate, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFCOMPANYVEHICLEVIN, ALIAS=ADFCompanyVehicleVin, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFCOMPANYVEHICLEUNITNUM, ALIAS=ADFCompanyVehicleUnitNum, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=TRAILERNUM, ALIAS=TrailerNum, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFCOMPANYVEHICLEUSE, ALIAS=ADFCompanyVehicleUse, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFCOMPANYVEHICLEOWNLEASE, ALIAS=ADFCompanyVehicleOwnLease, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFCOMPANYVEHICLEESTREPAIR, ALIAS=ADFCompanyVehicleEstRepair, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFCOMPANYVEHICLESEEN, ALIAS=ADFCompanyVehicleSeen, USAGE=A100V, ACTUAL=A100V, $

FIELDNAME=ADFCOMPANYVEHICLEDAMAGEDESC, ALIAS=ADFCompanyVehicleDamageDesc, USAGE=A200V, ACTUAL=A200V, $

FIELDNAME=ADFPROPERTYDAMAGE, ALIAS=ADFPropertyDamage, USAGE=TX50, ACTUAL=TX, $

FIELDNAME=ADFPROPERTYADDRESS, ALIAS=ADFPropertyAddress, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFPROPERTYOWNER, ALIAS=ADFPropertyOwner, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFPROPERTYPHONE, ALIAS=ADFPropertyPhone, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFPROPERTYCITY, ALIAS=ADFPropertyCity, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFPROPERTYSTATE, ALIAS=ADFPropertyState, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFPROPERTYZIP, ALIAS=ADFPropertyZip, USAGE=A100V, ACTUAL=A100V, $

FIELDNAME=ADFOTHERPARTYOWNER, ALIAS=ADFOtherPartyOwner, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFOTHERPARTYPHONE, ALIAS=ADFOtherPartyPhone, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFOTHERPARTYCITY, ALIAS=ADFOtherPartyCity, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFOTHERPARTYPROPERTYDMG, ALIAS=ADFOtherPartyPropertyDmg, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFINJURIES, ALIAS=ADFInjuries, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFFATALITIES, ALIAS=ADFFatalities, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=RMPADAATFATALITIES, ALIAS=RMPADAATFatalities, USAGE=I11, ACTUAL=I4, $

FIELDNAME=DASFIRSTNAME, ALIAS=DASFirstName, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=DASLASTNAME, ALIAS=DASLastName, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=DASCODRIVER, ALIAS=DASCoDriver, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=DASDATE, ALIAS=DASDate, USAGE=YYMD, ACTUAL=DATE,

MISSING=ON, $

FIELDNAME=DASTIME, ALIAS=DASTime, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=DASADDRESS, ALIAS=DASAddress, USAGE=A200V, ACTUAL=A200V, $

FIELDNAME=DASCITY, ALIAS=DASCity, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=DASSTATE, ALIAS=DASState, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=DASZIP, ALIAS=DASZip, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=DASUNITNUM, ALIAS=DASUni

Link to comment
Share on other sites

FIELDNAME=RM_DRIVERDETAILS, ALIAS=RM_DriverDetails, USAGE=A100V, ACTUAL=A100V, $

FIELDNAME=RM_MOTEL_HOSPITALINFO, ALIAS=RM_Motel_hospitalInfo, USAGE=A500V, ACTUAL=A500V, $

FIELDNAME=RM_AGENCYTYPE, ALIAS=RM_AgencyType, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=RM_ERIREPORT, ALIAS=RM_ERIReport, USAGE=A100V, ACTUAL=A100V, $

FIELDNAME=RM_ERIPHONE, ALIAS=RM_ERIPhone, USAGE=A100V, ACTUAL=A100V, $

FIELDNAME=RM_AGENCYNAME, ALIAS=RM_AgencyName, USAGE=A100V, ACTUAL=A100V, $

FIELDNAME=RM_OFFICERNAME, ALIAS=RM_OfficerName, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=RM_BADGE, ALIAS=RM_Badge, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=RM_CITATIONISSUED, ALIAS=RM_CitationIssued, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=RM_CITATIONDETAIL, ALIAS=RM_CitationDetail, USAGE=A100V, ACTUAL=A100V, $

FIELDNAME=RM_ARREST, ALIAS=RM_Arrest, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=RM_IMPOUND, ALIAS=RM_Impound, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=RM_NOTES, ALIAS=RM_Notes, USAGE=A200V, ACTUAL=A200V, $

FIELDNAME=ADFCOMPANYVEHICLEUNITTOWED, ALIAS=ADFCompanyVehicleUnitTowed, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFCOMPANYVEHICLECOSTCENTER, ALIAS=ADFCompanyVehicleCostCenter, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFCOMPANYVEHICLEDIVISION, ALIAS=ADFCompanyVehicleDivision, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFCOMPANYVEHICLEDAMAGEDETAIL, ALIAS=ADFCompanyVehicleDamageDetail, USAGE=A100V, ACTUAL=A100V, $

FIELDNAME=ADFCOMPANYVEHICLEST, ALIAS=ADFCompanyVehicleST, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFCOMPANYVEHICLETRAILERTOWED, ALIAS=ADFCompanyVehicleTrailerTowed, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFCOMPANYVEHICLEREPAIRCOST, ALIAS=ADFCompanyVehicleRepairCost, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFCOMPANYVEHICLEREPAIRPAID, ALIAS=ADFCompanyVehicleRepairPaid, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFCOMPANYVEHICLEREPAIRSUBRO, ALIAS=ADFCompanyVehicleRepairSubro, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFCOMPANYTRAILERREPAIRCOST, ALIAS=ADFCompanyTrailerRepairCost, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFCOMPANYTRAILERREPAIRPAID, ALIAS=ADFCompanyTrailerRepairPaid, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFCOMPANYTRAILERREPAIRSUBRO, ALIAS=ADFCompanyTrailerRepairSubro, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=TIVIN, ALIAS=TIVIN, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=TIPLATE, ALIAS=TIPlate, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=TIST, ALIAS=TIST, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=TIDIVISION, ALIAS=TIDivision, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=TICOSTCENTER, ALIAS=TICostCenter, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=TITRAILERTOWED, ALIAS=TITrailerTowed, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=TITRAILERDAMAGE, ALIAS=TITrailerDamage, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFCARGOPHOTOS, ALIAS=ADFCargoPhotos, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFCARGODAMAGED, ALIAS=ADFCargoDamaged, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFCARGODIVISION, ALIAS=ADFCargoDivision, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFWRECKERNEEDED, ALIAS=ADFWreckerNeeded, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFSAFETYPERSON, ALIAS=ADFSafetyPerson, USAGE=A100V, ACTUAL=A100V, $

FIELDNAME=ADFOTHERVECHILEDAMAGED, ALIAS=ADFOtherVechileDamaged, USAGE=A100V, ACTUAL=A100V, $

FIELDNAME=ADFREPORTEDBY, ALIAS=ADFReportedBy, USAGE=A100V, ACTUAL=A100V, $

FIELDNAME=RMCC, ALIAS=RMCC, USAGE=A100V, ACTUAL=A100V, $

FIELDNAME=RMCO, ALIAS=RMCO, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=RM_CARGODAMAGE, ALIAS=RM_CargoDamage, USAGE=TX50, ACTUAL=TX, $

FIELDNAME=RM_BRIEFDESCRIPTION, ALIAS=RM_BriefDescription, USAGE=TX50, ACTUAL=TX, $

FIELDNAME=RM_LANES, ALIAS=RM_Lanes, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=RM_DAYSSINCELOSS, ALIAS=RM_DaysSinceLoss, USAGE=I11, ACTUAL=I4, FIELDTYPE=R,

MISSING=ON, $

FIELDNAME=RM_TYPEOFLOSS, ALIAS=RM_TypeofLoss, USAGE=A100V, ACTUAL=A100V, $

FIELDNAME=RM_DIRECTION, ALIAS=RM_Direction, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=RM_TEST, ALIAS=RM_Test, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFPHOTOS, ALIAS=ADFPhotos, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=RM_ALERTEMAILBODY, ALIAS=RM_AlertEmailBody, USAGE=TX50, ACTUAL=TX, $

FIELDNAME=TPAADJUSTERNAME, ALIAS=TPAAdjusterName, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=TPAADJUSTEREMAIL, ALIAS=TPAAdjusterEmail, USAGE=A200V, ACTUAL=A200V, $

FIELDNAME=TPAADJUSTERPHONE, ALIAS=TPAAdjusterPhone, USAGE=A20V, ACTUAL=A20V, $

FIELDNAME=TPAADJUSTERFILENUMBER, ALIAS=TPAAdjusterFileNumber, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=TPAADJUSTERCOMPANYNAME, ALIAS=TPAAdjusterCompanyName, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=TPAADJUSTERNOTES, ALIAS=TPAAdjusterNotes, USAGE=TX50, ACTUAL=TX, $

FIELDNAME=RISKTYPE01, ALIAS=RiskType01, USAGE=I11, ACTUAL=I4, $

FIELDNAME=RISKTYPE02, ALIAS=RiskType02, USAGE=I11, ACTUAL=I4, $

FIELDNAME=RISKTYPE03, ALIAS=RiskType03, USAGE=I11, ACTUAL=I4, $

FIELDNAME=RISKTYPE04, ALIAS=RiskType04, USAGE=I11, ACTUAL=I4, $

FIELDNAME=RISKTYPE05, ALIAS=RiskType05, USAGE=I11, ACTUAL=I4, $

FIELDNAME=RISKTYPE06, ALIAS=RiskType06, USAGE=I11, ACTUAL=I4, $

FIELDNAME=RISKTYPE07, ALIAS=RiskType07, USAGE=I11, ACTUAL=I4, $

FIELDNAME=RISKTYPE08, ALIAS=RiskType08, USAGE=I11, ACTUAL=I4, $

FIELDNAME=INSURANCESTATUS01, ALIAS=InsuranceStatus01, USAGE=I11, ACTUAL=I4, $

FIELDNAME=INSURANCESTATUS02, ALIAS=InsuranceStatus02, USAGE=I11, ACTUAL=I4, $

FIELDNAME=INSURANCESTATUS03, ALIAS=InsuranceStatus03, USAGE=I11, ACTUAL=I4, $

FIELDNAME=INSURANCESTATUS04, ALIAS=InsuranceStatus04, USAGE=I11, ACTUAL=I4, $

FIELDNAME=INSURANCESTATUS05, ALIAS=InsuranceStatus05, USAGE=I11, ACTUAL=I4, $

FIELDNAME=INSURANCESTATUS06, ALIAS=InsuranceStatus06, USAGE=I11, ACTUAL=I4, $

FIELDNAME=INSURANCESTATUS07, ALIAS=InsuranceStatus07, USAGE=I11, ACTUAL=I4, $

FIELDNAME=INSURANCESTATUS08, ALIAS=InsuranceStatus08, USAGE=I11, ACTUAL=I4, $

FIELDNAME=LOADSHIFT, ALIAS=Loadshift, USAGE=I11, ACTUAL=I4, $

FIELDNAME=UNITDAMAGE01, ALIAS=UnitDamage01, USAGE=I11, ACTUAL=I4, $

FIELDNAME=UNITDAMAGE02, ALIAS=UnitDamage02, USAGE=I11, ACTUAL=I4, $

FIELDNAME=UNITDAMAGE03, ALIAS=UnitDamage03, USAGE=I11, ACTUAL=I4, $

FIELDNAME=UNITDAMAGE04, ALIAS=UnitDamage04, USAGE=I11, ACTUAL=I4, $

FIELDNAME=UNITDAMAGE05, ALIAS=UnitDamage05, USAGE=I11, ACTUAL=I4, $

FIELDNAME=UNITDAMAGE06, ALIAS=UnitDamage06, USAGE=I11, ACTUAL=I4, $

FIELDNAME=UNITDAMAGE07, ALIAS=UnitDamage07, USAGE=I11, ACTUAL=I4, $

FIELDNAME=UNITDAMAGE08, ALIAS=UnitDamage08, USAGE=I11, ACTUAL=I4, $

FIELDNAME=TRAILERDAMAGE01, ALIAS=TrailerDamage01, USAGE=I11, ACTUAL=I4, $

FIELDNAME=TRAILERDAMAGE02, ALIAS=TrailerDamage02, USAGE=I11, ACTUAL=I4, $

FIELDNAME=TRAILERDAMAGE03, ALIAS=TrailerDamage03, USAGE=I11, ACTUAL=I4, $

FIELDNAME=TRAILERDAMAGE04, ALIAS=TrailerDamage04, USAGE=I11, ACTUAL=I4, $

FIELDNAME=TRAILERDAMAGE05, ALIAS=TrailerDamage05, USAGE=I11, ACTUAL=I4, $

FIELDNAME=TRAILERDAMAGE06, ALIAS=TrailerDamage06, USAGE=I11, ACTUAL=I4, $

FIELDNAME=TRAILERDAMAGE07, ALIAS=TrailerDamage07, USAGE=I11, ACTUAL=I4, $

FIELDNAME=TRAILERDAMAGE08, ALIAS=TrailerDamage08, USAGE=I11, ACTUAL=I4, $

FIELDNAME=ROADCONDITION01, ALIAS=RoadCondition01, USAGE=I11, ACTUAL=I4, $

FIELDNAME=ROADCONDITION02, ALIAS=RoadCondition02, USAGE=I11, ACTUAL=I4, $

FIELDNAME=ROADCONDITION03, ALIAS=RoadCondition03, USAGE=I11, ACTUAL=I4, $

FIELDNAME=ROADCONDITION04, ALIAS=RoadCondition04, USAGE=I11, ACTUAL=I4, $

FIELDNAME=ROADCONDITION05, ALIAS=RoadCondition05, USAGE=I11, ACTUAL=I4, $

FIELDNAME=ROADCONDITION06, ALIAS=RoadCondition06, USAGE=I11, ACTUAL=I4, $

FIELDNAME=ROADCONDITION07, ALIAS=RoadCondition07, USAGE=I11, ACTUAL=I4, $

FIELDNAME=ROADCONDITION08, ALIAS=RoadCondition08, USAGE=I11, ACTUAL=I4, $

FIELDNAME=ROADCONDITION09, ALIAS=RoadCondition09, USAGE=I11, ACTUAL=I4, $

FIELDNAME=ROADCONDITION10, ALIAS=RoadCondition10, USAGE=I11, ACTUAL=I4, $

FIELDNAME=WEATHERCONDITION01, ALIAS=WeatherCondition01, USAGE=I11, ACTUAL=I4, $

FIELDNAME=WEATHERCONDITION02, ALIAS=WeatherCondition02, USAGE=I11, ACTUAL=I4, $

FIELDNAME=WEATHERCONDITION03, ALIAS=WeatherCondition03, USAGE=I11, ACTUAL=I4, $

FIELDNAME=WEATHERCONDITION04, ALIAS=WeatherCondition04, USAGE=I11, ACTUAL=I4, $

FIELDNAME=WEATHERCONDITION05, ALIAS=WeatherCondition05, USAGE=I11, ACTUAL=I4, $

FIELDNAME=WEATHERCONDITION06, ALIAS=WeatherCondition06, USAGE=I11, ACTUAL=I4, $

FIELDNAME=WEATHERCONDITION07, ALIAS=WeatherCondition07, USAGE=I11, ACTUAL=I4, $

FIELDNAME=WEATHERCONDITION08, ALIAS=WeatherCondition08, USAGE=I11, ACTUAL=I4, $

FIELDNAME=WEATHERCONDITION09, ALIAS=WeatherCondition09, USAGE=I11, ACTUAL=I4, $

FIELDNAME=WEATHERCONDITION10, ALIAS=WeatherCondition10, USAGE=I11, ACTUAL=I4, $

FIELDNAME=WEATHERCONDITION11, ALIAS=WeatherCondition11, USAGE=I11, ACTUAL=I4, $

FIELDNAME=WEATHERCONDITION12, ALIAS=WeatherCondition12, USAGE=I11, ACTUAL=I4, $

FIELDNAME=RESERVESPENDING01, ALIAS=ReservesPending01, USAGE=I11, ACTUAL=I4, $

FIELDNAME=RESERVESPENDING02, ALIAS=ReservesPending02, USAGE=I11, ACTUAL=I4, $

FIELDNAME=RESERVESPENDING03, ALIAS=ReservesPending03, USAGE=I11, ACTUAL=I4, $

FIELDNAME=RESERVESPENDING04, ALIAS=ReservesPending04, USAGE=I11, ACTUAL=I4, $

FIELDNAME=RESERVESPENDING05, ALIAS=ReservesPending05, USAGE=I11, ACTUAL=I4, $

FIELDNAME=RESERVESPENDING06, ALIAS=ReservesPending06, USAGE=I11, ACTUAL=I4, $

FIELDNAME=RESERVESPENDING07, ALIAS=ReservesPending07, USAGE=I11, ACTUAL=I4, $

FIELDNAME=RESERVESPENDING08, ALIAS=ReservesPending08, USAGE=I11, ACTUAL=I4, $

FIELDNAME=RESERVESPENDING09, ALIAS=ReservesPending09, USAGE=I11, ACTUAL=I4, $

FIELDNAME=RESERVESPENDING10, ALIAS=ReservesPending10, USAGE=I11, ACTUAL=I4, $

FIELDNAME=RESERVESPENDING11, ALIAS=ReservesPending11, USAGE=I11, ACTUAL=I4, $

FIELDNAME=RESERVESPENDING12, ALIAS=ReservesPending12, USAGE=I11, ACTUAL=I4, $

FIELDNAME=RESERVESPENDING13, ALIAS=ReservesPending13, USAGE=I11, ACTUAL=I4, $

FIELDNAME=RESERVESPENDING14, ALIAS=ReservesPending14, USAGE=I11, ACTUAL=I4, $

FIELDNAME=CARGODAMAGE01, ALIAS=CargoDamage01, USAGE=I11, ACTUAL=I4, $

FIELDNAME=CARGODAMAGE02, ALIAS=CargoDamage02, USAGE=I11, ACTUAL=I4, $

FIELDNAME=CARGODAMAGE03, ALIAS=CargoDamage03, USAGE=I11, ACTUAL=I4, $

FIELDNAME=CARGODAMAGE04, ALIAS=CargoDamage04, USAGE=I11, ACTUAL=I4, $

FIELDNAME=CARGODAMAGE05, ALIAS=CargoDamage05, USAGE=I11, ACTUAL=I4, $

FIELDNAME=CARGODAMAGE06, ALIAS=CargoDamage06, USAGE=I11, A

Link to comment
Share on other sites

Yes, sorry, TABLENAME=ShipsDM.dbo.DM_Accident is a table. When I generate sample data the results are the same - the date is 2 days off. The EBECON01 is pointing to the proper server instance - we have other applications pointing to that adapter as well and they are just fine.

I did do some more poking around and there are other dates within that table formatted as HYYMDs - those dates are correct. I tried reformatting the ones that are YYMD to HYYMDs but got the same results.

Link to comment
Share on other sites

Thats interesting too. If other dates are working and this one is not, that says theres something special about it.

I think Id start by narrowing down your Master file to temporarily get rid of all your DEFINE fields.

The goal is to make it as simple as possible.

Make a simple fex that returns just a few records so you can see if it matches what youre seeing with SQL Server Management Studio.

Next capture your generated SQL just to see if theres anything odd there.

Let me see if I remember the commands for that from memory:

SET TRACEALL=OFF

SET TRACEUSER=CLIENT

SET TRACEON=STMTRACE//CLIENT

SET TRACESTAMP=OFF

then

TABLE FILE DM_ACCIDENT

PRINT

ENTRYID

ADFACCIDENTDATE

-* Id also add a known good date field for comparison

DTDATECOMPLETED

WHERE ENTRYID EQ 7039

END

The hope is for you to just get a simple result. Grab the generated SQL and copy/paste it into SQL Server Management Studio.

If you still give different values (which it sounds like you will), then youve got a nice tidy reproduction of your issue to open a case with.

Let us know how that little test goes.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
  • Create New...