Does anyone know why the "render" of the data would be wrong? I changed it from the US format to the ISO 8601.
Edit: Adding some spaces in the equation helped.
Hmmm, from reading other functions it does seem that calc uses ; rather than the , I assumed, TIL
Thank you for pointing this out