PHP Import Date Type Cell Problem from Excel File

By
If you import a date type cell from Excel file in PHP, such as 2014-10-30, you probrablly get integer value like 41942. The solution is the following:
echo date($format,strtotime('1899-12-31+'.(41942-1).' days')); 2014-10-30

Comments

Post a Comment

Popular posts from this blog

Error [ERR_UNSUPPORTED_ESM_URL_SCHEME]: Only file and data URLs are supported by the default ESM loader.

By
Error [ERR_UNSUPPORTED_ESM_URL_SCHEME]: Only file and data URLs are supported by the default ESM loader. Received protocol 'node:' at Loader.defaultResolve [as _resolve] (internal/modules/esm/resolve.js:782:11) at Loader.resolve (internal/modules/esm/loader.js:85:40) at Loader.getModuleJob (internal/modules/esm/loader.js:229:28) at ModuleWrap. (internal/modules/esm/module_job.js:51:40) at link (internal/modules/esm/module_job.js:50:36) use stable node version, such as 17.8.0.
Read more