Advanced Search

Convert date to SQLite in Numbers

/ Published in: Other
Save to your folder(s)
Converts dates in Numbers to SQLite format.

Expand | Embed | Plain Text

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


Comments

You need to login to view comments.