ODK XLSForm Template - version number expression not working with French Excel

Thank you for this very useful template!

Beginning a new form, I've noticed that in Excel 2019, the formula that manages the version number doesn't works, because of an incomplete french adaptation of Excel I suppose:
=TEXTE(MAINTENANT(); "yyyymmddhhmmss") --> yyyy02dd193740

You just have to replace "yyyy" by "aaaa" and "dd" by "jj".
=TEXTE(MAINTENANT(); "aaaammjjhhmmss") --> 20240213193740

That's not an issue with LibreOffice.

3 Likes