I am using a Web Service Connection that has an input value called 'ModifiedOn' that is a date type. The problem that I have is that instead of sending a date string like '2008-08-04' it sends a number '39665' as the input to the web service method instead. Is there a way to force a date string to be returned instead of the number?
Here is the XML that is being sent to the web service method from Xcelsius:
<?xml version="1.0" encoding="UTF-8"?>
<soap:Envelope xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:n0="http://tempuri.org/" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<soap:Header />
<soap:Body>
<n0:SaveScenerio>
<n0:dash>
<n0:Scenerio CreatedBy="1" MedianIncome="54000" ModifiedBy="-1" Deleted="false" Population="56001" Title="Scenerio 5" ModelId="14" Year="2008" Description="" ScenerioId="5" SystemName="Scenerio 5" CreatedOn="39665" ModifiedOn="39665">
<n0:Model ModuleId="" Description="" ModifiedBy="-1" Deleted="false" CreatedBy="1" CreatedOn="39665" Title="My First Model EDITED 2" ModifiedOn="39665" ModelId="14">
</n0:Model>
<n0:RateRevenueResidential RateRevenueTypeId="" CreatedBy="1" NumOfCustomers="34000" NumNewCustomers="12000" RateRevenueId="" Deleted="false" MonthlyAvgUsage="10000" HookupCharge="74" VolumeCharge="0" VolumeRate="0.36" ScenerioId="" ModifiedBy="-1" CreatedOn="39665" FixedRate="20" ModifiedOn="39665">
<n0:RateRevenueType RateRevenueTypeId="" Description="">
</n0:RateRevenueType>
</n0:RateRevenueResidential>
<n0:RateRevenueCommercial RateRevenueTypeId="" CreatedBy="1" NumOfCustomers="150" NumNewCustomers="12002" RateRevenueId="" Deleted="false" MonthlyAvgUsage="20000" HookupCharge="75" VolumeCharge="0" VolumeRate="0.37" ScenerioId="" ModifiedBy="-1" CreatedOn="39665" FixedRate="30" ModifiedOn="39665">
<n0:RateRevenueType RateRevenueTypeId="" Description="">
</n0:RateRevenueType>
</n0:RateRevenueCommercial>
<n0:RateRevenueIndustrial RateRevenueTypeId="" CreatedBy="1" NumOfCustomers="34" NumNewCustomers="12003" RateRevenueId="" Deleted="false" MonthlyAvgUsage="30000" HookupCharge="76" VolumeCharge="0" VolumeRate="0.38" ScenerioId="" ModifiedBy="-1" CreatedOn="39665" FixedRate="40" ModifiedOn="39665">
<n0:RateRevenueType RateRevenueTypeId="" Description="">
</n0:RateRevenueType>
</n0:RateRevenueIndustrial>
<n0:RateRevenueGovernmental RateRevenueTypeId="" CreatedBy="1" NumOfCustomers="6" NumNewCustomers="12004" RateRevenueId="" Deleted="false" MonthlyAvgUsage="40000" HookupCharge="77" VolumeCharge="0" VolumeRate="0.39" ScenerioId="" ModifiedBy="-1" CreatedOn="39665" FixedRate="50" ModifiedOn="39665">
<n0:RateRevenueType RateRevenueTypeId="" Description="">
</n0:RateRevenueType>
</n0:RateRevenueGovernmental>
<n0:RateRevenueOther RateRevenueTypeId="" CreatedBy="1" NumOfCustomers="10" NumNewCustomers="12005" RateRevenueId="" Deleted="false" MonthlyAvgUsage="50000" HookupCharge="78" VolumeCharge="0" VolumeRate="0.4" ScenerioId="" ModifiedBy="-1" CreatedOn="39665" FixedRate="60" ModifiedOn="39665">
<n0:RateRevenueType RateRevenueTypeId="" Description="">
</n0:RateRevenueType>
</n0:RateRevenueOther>
</n0:Scenerio>
<n0:ErrorMessage>
</n0:ErrorMessage>
<n0:Forecast EstSystemCapacityYear4="" Industrial="0" Other="0" RateRevenue="0" EstSystemCapacityYear5="" HookupRevenue="0" CreatedBy="1" OtherRevenue="0" ModifiedBy="-1" CapitalFunds="0" ModifiedOn="39665" OperationsNMaintenanceExpenses="0" GeneralNAdminExpenses="0" OtherExpenses="0" Governmental="0" Deleted="false" ResidentialRates="0" CapitalImprvFundsYear2="0" CapitalImprvFundsYear3="0" CapitalImprvFundsYear4="0" CapitalImprvFundsYear5="0" CapitalExpYear2="0" CapitalExpYear3="0" CapitalExpYear4="0" CustResidential="0" CapitalExpYear5="0" Year="2008" EstSystemCapacityYear1="" Commercial="0" EstSystemCapacityYear2="" CreatedOn="39665" ScenerioId="" EstSystemCapacityYear3="" Mhi="0">
</n0:Forecast>
<n0:Revenue CapitalDWSRF="5600" AnnualHookup="4561076" CapitalGovLoan="5600.01" CapitalBusinessLoan="5600.02" CreatedBy="1" CapitalGrant="5601.03" AnnualOperationg="14292490.399999999" ModifiedBy="-1" Deleted="false" OtherInterestIncome="5600" OtherRevenue="5600" CapitalWithdraw="5602.04" ScenerioId="" CapitalOther="5603.05" OtherFeesNServiceCharges="5600" AnnualRate="9731414.399999999" CreatedOn="39665" AnnualOther="16800" ModifiedOn="39665">
</n0:Revenue>
<n0:Expense OpsMartriesNSupplies="1000000" CapitalNonFacility="1000000" AdminEngineering="1000000" ModifiedBy="-1" OpsMonitoring="1000000" Deleted="false" CreatedBy="1" OpsTransportation="1000000" AdminConservation="1000000" ModifiedOn="39665" CapitalDebtService="1000000" OpsMisc="1000000" AdminMisc="1000000" OpsUnaccountedWater="1000000" OtherDepreciation="1000000" OpsSalariesNBenefits="1000000" AdminSalareisNBenefits="1000000" OtherDeductionsFeesExp="1000000" OpsPowerNUtility="1000000" AdminOfficeSupplies="1000000" CapitalNewFacilities="1000000" AdminInsurance="1000000" ScenerioId="" OpsChemicalNTreatment="1000000" CapitalOther="1000000" AdminLegalNAccounting="1000000" CreatedOn="39665" CapitalReplacement="1000000" CapitalLeakageRepair="1000000">
</n0:Expense>
</n0:dash>
</n0:SaveScenerio>
</soap:Body>
</soap:Envelope>
Edited by: Aaron Jackson on Aug 7, 2008 10:44 PM