Hope we all had a great Christmas!
I am trying to run a query that selects a member every 365 days so we
can send them a domain reminder.
For my test (because i'm too lazy to count out someone with hundreds of
days :) ) I am using a known member at around 27/28 days
Now if I use this if finds the member, it doesn't find them if I go
under to say 27 days, I've used the DATE_SUB many times before, but
never for an exact match.
SELECT * FROM `member` WHERE AddedOn>=DATE_SUB(CURDATE(), INTERVAL 28
Now trying to get an exact match, fails.
SELECT * FROM `member` WHERE AddedOn=DATE_SUB(CURDATE(), INTERVAL 28
Also tried one by one up to 30 and down to 25 days,
Would someone please mind slapping me a good one reminding me what I've
done wrong :)
I thought CURDATE ignored the hours/mins/secs etc, but it seems it does