Im trying to add the above to the settings of calc “date acceptance pattern” but im not getting any success.
Sorry to bother, i figured out. i had imported a csv and on the import page i forgot to set the date column to date format. after re-importig, the dates were rightfully recognized.
2 Likes
No need to do that. Just check “Detect special numbers”. This setting is preserved for the next session.
1 Like
Will try that next time i import a csv, thanks