[related] When using Date ranges to define a BETWEEN clause in MySQL, beware that the upper date limit is excluded from the results (1 day less). Unsure about the case when the Date range is exclusive (2 days less?).