Day 67

[nsd_user663_1695]

I'm still smoke free @ day 67

Working IT i made an SQL query to tell me how many days and months i have quit. It says day 67 is not month 3 yet, sheesh. Hope everyone is doing well and has remained smoke free!

SELECT DateDiff(dd, '3/10/2007 12:00 PM', GetDate()) As [Smoke Free Days]

[nsd_user663_1704]

Thank you!! thank you!!

A person in the know!! makes me right!

Ah thought i was friggin mad, not that i can SQL meself lol but two quit meters are wrong!

check my posts from this thread earlier nosmokingday.org.uk/forum/s...

I reckon the month of feb must of confused it though that should not be the case!

Are you sure your SQL prog does not count month 3 as 3 months completed?

Only logically 67 days is 2+ months, we call it 'entering' month 3 your prog counts it as 2+ months, no?

Whatever, like , you have like done soooooo well in your quit!! totally

Your a star man x x

Ooooh brain overloads and i go all goofy! hehe

[nsd_user663_1695]

I had not thought about this yet, dates are so confusing. I won't pretend to know the answer but here's what I am going to do....

Basically, SQL (a lot of automated counters online use this, not all) ignores days when working with months. Anything lower than a month can be calculated the way we would think because its all just math; 60 seconds = 1 minute, 60 minutes = 1 hour, 24 hours = 1 day, 7 days = 1 week, ? weeks = 1 month. At this point it ONLY looks at month and not day, so 5/31/2007 > 6/1/2007 = 1 month. However, 6/1/2007 > 6/2/2007 = 0 months.

Sticking to how we counted days 1, 2, 3, 4 and so on, we needed to complete week 1 before we could say "I have been quit for 1 week". I guess that leaves the only way for us to calculate months for short periods of time is to use a number of days (ill go with 30, because months are relative). So my 68 days = 2.266 Months, I have to hit 90 before i COMPLETE 3 months.

To each his/her own though

[nsd_user663_1704]

Hmmm

Yup, I figured the same, I figured however that 28 days per month would be a sensible figure given that 7 is a multiple (7 days per week)

30D didn't occur to me and I didn't look long enough to figure it lol

But I suppose the 30D is average. but you're right my quit meter says

2M 2W 5D (79 days)

2M*30D=60D

2W*7D=14D

60D+14D+5D=79D

So your absolutely right

Guess the most sensible thing would be to work in just weeks and days as they are constant.