Convert date to SQLite in Numbers

/ Published in: Other
Save to your folder(s)

Converts dates in Numbers to SQLite format.

Copy this code and paste it in your HTML
  1. =CONCATENATE(YEAR(F2), "-", IF(LEN(MONTH(F2))<2, "0",), MONTH(F2), "-", IF(LEN(DAY(F2))<2, "0",), DAY(F2))

Report this snippet


RSS Icon Subscribe to comments

You need to login to post a comment.