Posted By

fonnesbeck on 08/01/09


Tagged

date numbers SQLite iWork


Versions (?)

Convert date to SQLite in Numbers


 / Published in: Other
 

Converts dates in Numbers to SQLite format.

  1. =CONCATENATE(YEAR(F2), "-", IF(LEN(MONTH(F2))<2, "0",), MONTH(F2), "-", IF(LEN(DAY(F2))<2, "0",), DAY(F2))

Report this snippet  

You need to login to post a comment.