I have a Power Automate flow that is reading from Excel, and is storing date values in a SQL table.
29/03/2023 is being stored as 45014.75, and 17/10/2023 is being stored as 45216.3958333333.
Does anyone know how these values can be converted back to actual dates? I thought I could do something like the below but it errors out.
SELECT
convert(datetime,'45014.75', 103), --29/03/2023
convert(datetime,'45216.3958333333', 103) --17/10/2023