OK minor issue in handling these queries. The dates in MySQL are long numerical values. They aren't actually dates. It also doesn't seem to be the standard UNIX "seconds since 1900" value since those are in the range of 2 billion and these are in the range of 1.3 billion. What would the numeric value for January 1, 2018 be?

UPDATE OK I found another value that some people use, which is the "seconds since January 1 1970" which seems to be close to these values. So I will calculate based on that.

Last edited by BellaOnline; 05/20/2018 4:12 PM.

Lisa Shea, owner, BellaOnline.com
BellaOnline Website
BellaOnline Forums - UBB since Apr 2002 - 58,000 members / 850,000 posts