LXer: Hunting Excel date twins
by LXer from LinuxQuestions.org on (#5F332)
Published at LXer:
Excel files can sometimes contain the same record with dates four years and one day apart. These pseudo-duplicates are the result of Microsoft's choice of starting date for serial date numbers. The issue is explained in this post and I demonstrate one way to find Excel date pairs with command-line tools.
Read More...
Excel files can sometimes contain the same record with dates four years and one day apart. These pseudo-duplicates are the result of Microsoft's choice of starting date for serial date numbers. The issue is explained in this post and I demonstrate one way to find Excel date pairs with command-line tools.
Read More...