Excel Tips
Date/Datetime When using Power Automate to extract Excel data into CSV, the date value might be converted to a numeric value. That numeric value is the date difference between 30/DEC/1899 and the actual date value. If the numeric value is a integer, that represent a date (or time portion all 0s). If the numeric value is a float/decimal, that represent a datetime value.
So, if you need to convert that integer value back to it’s original date value in SQL:
Posted by John Liu Saturday, July 27, 2024