fonnesbeck
3/25/2010 - 12:02 AM

Convert date to SQLite in Numbers

Convert date to SQLite in Numbers

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