3 ms·
I was developing an interface to read a .xslx file to import a table within a Qt/C++ program, and this detailed showed up in my conversions to Unix time. It tur
by jwrallie 7mo ago
I was developing an interface to read a .xslx file to import a table within a Qt/C++ program, and this detailed showed up in my conversions to Unix time. It turns out Claude was amazing and brought up this issue as soon as Excel was mentioned, but terrible at actually fixing up the calculations.
I'd prefer using a .csv with dates already converted to Unix time, but no luck convincing the other people involved.
- jagged-chisel 7mo agoYou should export datetimes as human-readable strings. Helps debugging. (And does nothing to guarantee they’re correct, just like every other attempt at a solution.)