Aglet

Investigate Serial and Formatted Spreadsheet Dates

Investigate spreadsheet dates by separating the cell’s display from the value written to the export. A serial value needs a known date-system contract, while text needs an unambiguous format rule. Build comparisons from independently known dates and keep later timezone conversion outside the initial parsing hypothesis unless the evidence reaches it.

Build a useful investigation brief

  1. Build known-date export fixtures

    Create controlled exports from the relevant supported producer using known dates and any documented serial representation. Include text that distinguishes day/month order and a boundary case appropriate to the supported date system. Record expected calendar values independently rather than deriving them through the importer’s current conversion routine.

  2. Trace representation and type selection

    Inspect source text, inferred field type, selected date format, conversion result, and destination type. Find the first incorrect value. Check whether preview and execution use the same producer context and whether a numeric-looking date is prematurely treated as an ordinary number before the date conversion rule can apply.

  3. Separate parsing from later shifts

    Compare the parsed calendar value with its stored and displayed representation. Where a time component exists, record timezone assumptions separately. Test one implicated format or conversion change against the entire fixture set so repairing a serial case does not silently reinterpret already supported explicit date strings under a different convention.

What to carry forward

Deliver a source-format matrix, interpretation context, and first divergent conversion. State which ambiguous values cannot be resolved without producer information. A supported correction preserves documented date meaning or rejects unsupported representations clearly; it should not infer an arbitrary offset merely because that makes one example match the expected display.

Technical background: Microsoft support.

Keep the decision with the work.

Use a Work Item in Aglet to record the problem, the evidence you have, and the next decision. Add an owner and priority, then keep updates in the discussion so the next person can follow the reasoning.

Create an account See the product workflow