advanced code snippet search

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.

Expand | Embed | Plain Text 
  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.