For example, to determine the difference between two dates, you can subtract one date from the other.
Dates and times are values and, therefore, can be added, subtracted, and included in other calculations. Excel stores times as decimal fractions because time is considered a portion of a day. Microsoft Excel stores dates as sequential numbers known as serial values. How Microsoft Excel stores dates and times They are stored as ‘sequential numbers’ or ‘serial values’.Īs an example November 6th, 2006 01:23:45 is stored as ‘39027.0581597222’.ĭoes anyone know a way, in wM Developer, of converting the date from that decimal number to a more ‘readable’ format? We’re currently using Developer v6.1.Īt this time, we’re unsure whether or not the date in the Excel file can be generated in a more standard way, but we figured we’d try all avenues first.Īs a short follow up, we already have a service (incrementDate) that can properly add the correct number of days, but it’s mostly the time portion (the decimal part) that we’re having trouble with.
We’re having an issue where an MS Excel file is generated by an external source and it’s our job to create a webMethods flow service to pick up the file, parse it, and put the data in a target system.Įverything is fine, except for the way that the dates are stored in the Excel file.
0 kommentar(er)
