I am having the same issue "ValueError: '-' is a bad directive in format '%a %-d %b %Y'"

The trouble is that this is happening after removing all the code except 2 lines.

from datetime import datetime
df=xl("output[[#All],[Event]:[Taste]]", headers=True)

Is there a error cache or similar with Excel?