DateValue in demos is culture specific

govert / SQLiteForExcel

A lightweight wrapper to give access to the SQLite3 library from VBA.

MIT License

256 stars 81 forks source link

Open sshikov opened 8 years ago

sshikov commented 8 years ago

I.e. DateValue("1 Jan 2000") doesn't work on machine with Russian locale, for example.

sshikov commented 8 years ago

But DateValue("2000/01/01") does.

govert commented 8 years ago

Yes - DateValue is not so useful. Would you like to make a pull request that changes those to DateSerial(...)?