I have seen in the past a similar behaviour on Mac computers.
The issue in that instances was caused by the date format.
For example, date format #Jan. 1, 1970# was recognized in Windows but not in Mac.
When I replaced it with #1970-01-01# it was recognized on both OS
If that is the case please refer to the article below.
Hope this help