This is an Excel issue, not an Ignition issue. That said, Excel is very, very bad at this. EDIT: Phil beat me to that point.
Unfortunately, even using the built-in functions, Excel rarely uses a useful format.
I updated this function to allow an arbitrary date format, or use the deafult 'yyyy-MM-dd HH:mm:ss'.
1 Like