How to input dates

This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

  • How to input dates

    I need
    - to write dates in German datum format (dd.mm.yyyy) in database.
    - to extract month and year out of datum (did try by function "text")
    - to sort by datum

    But typing "01.01.2011" in spreadsheet results in "1012011". Reading this out of spreadsheet shows date "15.10.4670" - quite different from "01.01.2011"!

    Formatting cell as "datum" prior to typing data has no effect.

    Typing data as text is working. But for text-elements function "text(element;"mmm")" is not working. And there is no built-in function to transform text in numbers /dates.

    Any idea? Anybody to help me?

    Mark