LessThanDot

by **chrissie1** on Fri Jan 30, 2009 9:54 am

Making a simple calendar, I find that all these months with a different number of days is confussing. So I would like to have a calendar with 30 days per month from now on and 12 months a year. The only problem is that It will no longer be going with the sun. The sun being a 365 day/year cycle the new calendar has 360 days/year. So I need to compensate but only by adding a 13 month at certain years. Write me a program that calculates when to add a month to keep in synch more or less.

You can start at the 1st of january 2009.
Desired output.

new calendar year	number of months	old calendar year	new calendar date	old calendar date (dd/mm/yyyy)
1	12	2009	1/1/1	1/1/2009
2	12	2009	1/1/2	26/12/2009
3	12	2010	1/1/3	20/12/2010

Above data could be wrong ;-)

Don't forget the leap years.

by **SQLDenis** on Fri Jan 30, 2009 8:47 pm

is this correct?

2009-01-01 00:00:00.000 2009-12-27 00:00:00.000
2009-12-27 00:00:00.000 2010-12-22 00:00:00.000
2010-12-22 00:00:00.000 2011-12-17 00:00:00.000
2011-12-17 00:00:00.000 2013-01-10 00:00:00.000
2013-01-10 00:00:00.000 2014-01-05 00:00:00.000
2014-01-05 00:00:00.000 2014-12-31 00:00:00.000
2014-12-31 00:00:00.000 2016-01-25 00:00:00.000
2015-12-26 00:00:00.000 2017-01-19 00:00:00.000
2017-01-19 00:00:00.000 2018-01-14 00:00:00.000
2018-01-14 00:00:00.000 2019-02-08 00:00:00.000
2019-01-09 00:00:00.000 2020-02-03 00:00:00.000
2020-01-04 00:00:00.000 2021-01-28 00:00:00.000
2021-01-28 00:00:00.000 2022-02-22 00:00:00.000
2022-01-23 00:00:00.000 2023-02-17 00:00:00.000
2023-01-18 00:00:00.000 2024-02-12 00:00:00.000
2024-01-13 00:00:00.000 2025-03-08 00:00:00.000
2025-02-06 00:00:00.000 2026-03-03 00:00:00.000
2026-02-01 00:00:00.000 2027-02-26 00:00:00.000
2027-01-27 00:00:00.000 2028-03-22 00:00:00.000
2028-01-22 00:00:00.000 2029-03-17 00:00:00.000
2029-02-15 00:00:00.000 2030-03-12 00:00:00.000

by **SQLDenis** on Fri Jan 30, 2009 9:43 pm

BTW here is the code in T-SQL for the next 200 years

tsqlLine number Off | Show | Select all

Code is hidden, SHOW

I still have a slight problem, will fix it tomorrow since I have to run now

by **chrissie1** on Fri Jan 30, 2009 9:52 pm

My solution and results

vbnetLine number Off | Show | Select all

Code is hidden, SHOW

textLine number Off | Show | Select all

new year | months | old year | New date | old date
------------------------------------------------------
1 | 12 | 2009 | 01/01/1 | 01/01/2009
2 | 12 | 2009 | 01/01/2 | 27/12/2009
3 | 12 | 2010 | 01/01/3 | 22/12/2010
4 | 12 | 2011 | 01/01/4 | 17/12/2011
5 | 12 | 2012 | 01/01/5 | 11/12/2012
6 | 12 | 2013 | 01/01/6 | 06/12/2013
7 | 13 | 2014 | 01/01/7 | 31/12/2014
8 | 12 | 2015 | 01/01/8 | 26/12/2015
9 | 12 | 2016 | 01/01/9 | 20/12/2016
10 | 12 | 2017 | 01/01/10 | 15/12/2017
11 | 12 | 2018 | 01/01/11 | 10/12/2018
12 | 12 | 2019 | 01/01/12 | 05/12/2019
13 | 13 | 2020 | 01/01/13 | 29/12/2020
14 | 12 | 2021 | 01/01/14 | 24/12/2021
15 | 12 | 2022 | 01/01/15 | 19/12/2022
16 | 12 | 2023 | 01/01/16 | 14/12/2023
17 | 12 | 2024 | 01/01/17 | 08/12/2024
18 | 12 | 2025 | 01/01/18 | 03/12/2025
19 | 13 | 2026 | 01/01/19 | 28/12/2026
20 | 12 | 2027 | 01/01/20 | 23/12/2027
21 | 12 | 2028 | 01/01/21 | 17/12/2028
22 | 12 | 2029 | 01/01/22 | 12/12/2029
23 | 12 | 2030 | 01/01/23 | 07/12/2030
24 | 12 | 2031 | 01/01/24 | 02/12/2031
25 | 13 | 2032 | 01/01/25 | 26/12/2032
26 | 12 | 2033 | 01/01/26 | 21/12/2033
27 | 12 | 2034 | 01/01/27 | 16/12/2034
28 | 12 | 2035 | 01/01/28 | 11/12/2035
29 | 12 | 2036 | 01/01/29 | 05/12/2036
30 | 13 | 2037 | 01/01/30 | 30/12/2037
31 | 12 | 2038 | 01/01/31 | 25/12/2038
32 | 12 | 2039 | 01/01/32 | 20/12/2039
33 | 12 | 2040 | 01/01/33 | 14/12/2040
34 | 12 | 2041 | 01/01/34 | 09/12/2041
35 | 12 | 2042 | 01/01/35 | 04/12/2042
36 | 13 | 2043 | 01/01/36 | 29/12/2043
37 | 12 | 2044 | 01/01/37 | 23/12/2044
38 | 12 | 2045 | 01/01/38 | 18/12/2045
39 | 12 | 2046 | 01/01/39 | 13/12/2046
40 | 12 | 2047 | 01/01/40 | 08/12/2047
41 | 12 | 2048 | 01/01/41 | 02/12/2048
42 | 13 | 2049 | 01/01/42 | 27/12/2049
43 | 12 | 2050 | 01/01/43 | 22/12/2050
44 | 12 | 2051 | 01/01/44 | 17/12/2051
45 | 12 | 2052 | 01/01/45 | 11/12/2052
46 | 12 | 2053 | 01/01/46 | 06/12/2053
47 | 13 | 2054 | 01/01/47 | 31/12/2054
48 | 12 | 2055 | 01/01/48 | 26/12/2055
49 | 12 | 2056 | 01/01/49 | 20/12/2056
50 | 12 | 2057 | 01/01/50 | 15/12/2057
51 | 12 | 2058 | 01/01/51 | 10/12/2058
52 | 12 | 2059 | 01/01/52 | 05/12/2059
53 | 13 | 2060 | 01/01/53 | 29/12/2060
54 | 12 | 2061 | 01/01/54 | 24/12/2061
55 | 12 | 2062 | 01/01/55 | 19/12/2062
56 | 12 | 2063 | 01/01/56 | 14/12/2063
57 | 12 | 2064 | 01/01/57 | 08/12/2064
58 | 12 | 2065 | 01/01/58 | 03/12/2065
59 | 13 | 2066 | 01/01/59 | 28/12/2066
60 | 12 | 2067 | 01/01/60 | 23/12/2067
61 | 12 | 2068 | 01/01/61 | 17/12/2068
62 | 12 | 2069 | 01/01/62 | 12/12/2069
63 | 12 | 2070 | 01/01/63 | 07/12/2070
64 | 12 | 2071 | 01/01/64 | 02/12/2071
65 | 13 | 2072 | 01/01/65 | 26/12/2072
66 | 12 | 2073 | 01/01/66 | 21/12/2073
67 | 12 | 2074 | 01/01/67 | 16/12/2074
68 | 12 | 2075 | 01/01/68 | 11/12/2075
69 | 12 | 2076 | 01/01/69 | 05/12/2076
70 | 13 | 2077 | 01/01/70 | 30/12/2077
71 | 12 | 2078 | 01/01/71 | 25/12/2078
72 | 12 | 2079 | 01/01/72 | 20/12/2079
73 | 12 | 2080 | 01/01/73 | 14/12/2080
74 | 12 | 2081 | 01/01/74 | 09/12/2081
75 | 12 | 2082 | 01/01/75 | 04/12/2082
76 | 13 | 2083 | 01/01/76 | 29/12/2083
77 | 12 | 2084 | 01/01/77 | 23/12/2084
78 | 12 | 2085 | 01/01/78 | 18/12/2085
79 | 12 | 2086 | 01/01/79 | 13/12/2086
80 | 12 | 2087 | 01/01/80 | 08/12/2087
81 | 12 | 2088 | 01/01/81 | 02/12/2088
82 | 13 | 2089 | 01/01/82 | 27/12/2089
83 | 12 | 2090 | 01/01/83 | 22/12/2090
84 | 12 | 2091 | 01/01/84 | 17/12/2091
85 | 12 | 2092 | 01/01/85 | 11/12/2092
86 | 12 | 2093 | 01/01/86 | 06/12/2093
87 | 13 | 2094 | 01/01/87 | 31/12/2094
88 | 12 | 2095 | 01/01/88 | 26/12/2095
89 | 12 | 2096 | 01/01/89 | 20/12/2096
90 | 12 | 2097 | 01/01/90 | 15/12/2097
91 | 12 | 2098 | 01/01/91 | 10/12/2098
92 | 12 | 2099 | 01/01/92 | 05/12/2099
93 | 13 | 2100 | 01/01/93 | 30/12/2100
94 | 12 | 2101 | 01/01/94 | 25/12/2101
95 | 12 | 2102 | 01/01/95 | 20/12/2102
96 | 12 | 2103 | 01/01/96 | 15/12/2103
97 | 12 | 2104 | 01/01/97 | 09/12/2104
98 | 12 | 2105 | 01/01/98 | 04/12/2105
99 | 13 | 2106 | 01/01/99 | 29/12/2106
100 | 12 | 2107 | 01/01/100 | 24/12/2107
101 | 12 | 2108 | 01/01/101 | 18/12/2108

Code is hidden, SHOW

by **SQLDenis** on Fri Jan 30, 2009 9:55 pm

My results don't like right after I add the 13th month :-(

by **gmmastros** on Sat Jan 31, 2009 3:47 pm

Chrissie1,

I think there is a minor flaw with your output. To accommodate the 5 missing days each year, we need to occasionally add a 13th month. Since each month is supposed to have exactly 30 days, this means we need to add an extra month every 6 years. You appear to be doing this, but.... shouldn't the first year with 13 months be year 6. In your output, the first year you have with 13 months is year 7. After that, every 6th year has 13 months, as I would expect.

My submission:

TSQLLine number Off | Show | Select all

DECLARE @Temp TABLE(RowId INT IDENTITY(1,1), YearValue INT, MonthValue INT, DayValue INT)
INSERT INTO @Temp(YearValue, MonthValue, DayValue)
SELECT YearValue, MonthValue, DayValue
FROM (
SELECT Number AS YearValue
FROM Master..spt_Values
WHERE Type = 'p'
And Number Between 1 and 200
) AS Years
Cross Join (
SELECT Number AS MonthValue
FROM master..spt_values
WHERE Type = 'p'
And Number Between 1 and 12
) AS Months
Cross Join (
SELECT Number AS DayValue
FROM master..spt_values
WHERE type = 'p'
And Number Between 1 and 30
) AS Days
UNION All
-- Accomodate a 13th month every 6 years.
SELECT YearValue, 13, DayValue
FROM (
SELECT Number AS YearValue
FROM Master..spt_Values
WHERE Type = 'p'
And Number Between 1 and 200
And Number % 6 = 0
) AS Years
Cross Join (
SELECT Number AS DayValue
FROM master..spt_values
WHERE type = 'p'
And Number Between 1 and 30
) AS Days
ORDER BY YearValue, MonthValue, DayValue
SELECT T.YearValue,
A.MonthCount,
CONVERT(VARCHAR(10), DayValue) + '/' + CONVERT(VARCHAR(10), MonthValue) + '/' + CONVERT(VARCHAR(10), T.YearValue) AS NewCalendarDate,
CONVERT(VARCHAR(10), DATEADD(DAY, RowId - 1, '20090101'), 103) AS OldCalendarDate
FROM @Temp T
INNER Join (
SELECT YearValue, COUNT(DISTINCT MonthValue) AS MonthCount
FROM @Temp
GROUP BY YearValue
) AS A
ON T.YearValue = A.YearValue
WHERE DayValue = 1 And MonthValue = 1
ORDER BY RowId

Code is hidden, SHOW

Output:

textLine number Off | Show | Select all

YearValue MonthCount NewCalendarDate OldCalendarDate
----------- ----------- -------------------------------- ---------------
1 12 1/1/1 01/01/2009
2 12 1/1/2 27/12/2009
3 12 1/1/3 22/12/2010
4 12 1/1/4 17/12/2011
5 12 1/1/5 11/12/2012
6 13 1/1/6 06/12/2013
7 12 1/1/7 31/12/2014
8 12 1/1/8 26/12/2015
9 12 1/1/9 20/12/2016
10 12 1/1/10 15/12/2017
11 12 1/1/11 10/12/2018
12 13 1/1/12 05/12/2019
13 12 1/1/13 29/12/2020
14 12 1/1/14 24/12/2021
15 12 1/1/15 19/12/2022
16 12 1/1/16 14/12/2023
17 12 1/1/17 08/12/2024
18 13 1/1/18 03/12/2025
19 12 1/1/19 28/12/2026
20 12 1/1/20 23/12/2027
21 12 1/1/21 17/12/2028
22 12 1/1/22 12/12/2029
23 12 1/1/23 07/12/2030
24 13 1/1/24 02/12/2031
25 12 1/1/25 26/12/2032
26 12 1/1/26 21/12/2033
27 12 1/1/27 16/12/2034
28 12 1/1/28 11/12/2035
29 12 1/1/29 05/12/2036
30 13 1/1/30 30/11/2037
31 12 1/1/31 25/12/2038
32 12 1/1/32 20/12/2039
33 12 1/1/33 14/12/2040
34 12 1/1/34 09/12/2041
35 12 1/1/35 04/12/2042
36 13 1/1/36 29/11/2043
37 12 1/1/37 23/12/2044
38 12 1/1/38 18/12/2045
39 12 1/1/39 13/12/2046
40 12 1/1/40 08/12/2047
41 12 1/1/41 02/12/2048
42 13 1/1/42 27/11/2049
43 12 1/1/43 22/12/2050
44 12 1/1/44 17/12/2051
45 12 1/1/45 11/12/2052
46 12 1/1/46 06/12/2053
47 12 1/1/47 01/12/2054
48 13 1/1/48 26/11/2055
49 12 1/1/49 20/12/2056
50 12 1/1/50 15/12/2057
51 12 1/1/51 10/12/2058
52 12 1/1/52 05/12/2059
53 12 1/1/53 29/11/2060
54 13 1/1/54 24/11/2061
55 12 1/1/55 19/12/2062
56 12 1/1/56 14/12/2063
57 12 1/1/57 08/12/2064
58 12 1/1/58 03/12/2065
59 12 1/1/59 28/11/2066
60 13 1/1/60 23/11/2067
61 12 1/1/61 17/12/2068
62 12 1/1/62 12/12/2069
63 12 1/1/63 07/12/2070
64 12 1/1/64 02/12/2071
65 12 1/1/65 26/11/2072
66 13 1/1/66 21/11/2073
67 12 1/1/67 16/12/2074
68 12 1/1/68 11/12/2075
69 12 1/1/69 05/12/2076
70 12 1/1/70 30/11/2077
71 12 1/1/71 25/11/2078
72 13 1/1/72 20/11/2079
73 12 1/1/73 14/12/2080
74 12 1/1/74 09/12/2081
75 12 1/1/75 04/12/2082
76 12 1/1/76 29/11/2083
77 12 1/1/77 23/11/2084
78 13 1/1/78 18/11/2085
79 12 1/1/79 13/12/2086
80 12 1/1/80 08/12/2087
81 12 1/1/81 02/12/2088
82 12 1/1/82 27/11/2089
83 12 1/1/83 22/11/2090
84 13 1/1/84 17/11/2091
85 12 1/1/85 11/12/2092
86 12 1/1/86 06/12/2093
87 12 1/1/87 01/12/2094
88 12 1/1/88 26/11/2095
89 12 1/1/89 20/11/2096
90 13 1/1/90 15/11/2097
91 12 1/1/91 10/12/2098
92 12 1/1/92 05/12/2099
93 12 1/1/93 30/11/2100
94 12 1/1/94 25/11/2101
95 12 1/1/95 20/11/2102
96 13 1/1/96 15/11/2103
97 12 1/1/97 09/12/2104
98 12 1/1/98 04/12/2105
99 12 1/1/99 29/11/2106
100 12 1/1/100 24/11/2107
101 12 1/1/101 18/11/2108
102 13 1/1/102 13/11/2109
103 12 1/1/103 08/12/2110
104 12 1/1/104 03/12/2111
105 12 1/1/105 27/11/2112
106 12 1/1/106 22/11/2113
107 12 1/1/107 17/11/2114
108 13 1/1/108 12/11/2115
109 12 1/1/109 06/12/2116
110 12 1/1/110 01/12/2117
111 12 1/1/111 26/11/2118
112 12 1/1/112 21/11/2119
113 12 1/1/113 15/11/2120
114 13 1/1/114 10/11/2121
115 12 1/1/115 05/12/2122
116 12 1/1/116 30/11/2123
117 12 1/1/117 24/11/2124
118 12 1/1/118 19/11/2125
119 12 1/1/119 14/11/2126
120 13 1/1/120 09/11/2127
121 12 1/1/121 03/12/2128
122 12 1/1/122 28/11/2129
123 12 1/1/123 23/11/2130
124 12 1/1/124 18/11/2131
125 12 1/1/125 12/11/2132
126 13 1/1/126 07/11/2133
127 12 1/1/127 02/12/2134
128 12 1/1/128 27/11/2135
129 12 1/1/129 21/11/2136
130 12 1/1/130 16/11/2137
131 12 1/1/131 11/11/2138
132 13 1/1/132 06/11/2139
133 12 1/1/133 30/11/2140
134 12 1/1/134 25/11/2141
135 12 1/1/135 20/11/2142
136 12 1/1/136 15/11/2143
137 12 1/1/137 09/11/2144
138 13 1/1/138 04/11/2145
139 12 1/1/139 29/11/2146
140 12 1/1/140 24/11/2147
141 12 1/1/141 18/11/2148
142 12 1/1/142 13/11/2149
143 12 1/1/143 08/11/2150
144 13 1/1/144 03/11/2151
145 12 1/1/145 27/11/2152
146 12 1/1/146 22/11/2153
147 12 1/1/147 17/11/2154
148 12 1/1/148 12/11/2155
149 12 1/1/149 06/11/2156
150 13 1/1/150 01/11/2157
151 12 1/1/151 26/11/2158
152 12 1/1/152 21/11/2159
153 12 1/1/153 15/11/2160
154 12 1/1/154 10/11/2161
155 12 1/1/155 05/11/2162
156 13 1/1/156 31/10/2163
157 12 1/1/157 24/11/2164
158 12 1/1/158 19/11/2165
159 12 1/1/159 14/11/2166
160 12 1/1/160 09/11/2167
161 12 1/1/161 03/11/2168
162 13 1/1/162 29/10/2169
163 12 1/1/163 23/11/2170
164 12 1/1/164 18/11/2171
165 12 1/1/165 12/11/2172
166 12 1/1/166 07/11/2173
167 12 1/1/167 02/11/2174
168 13 1/1/168 28/10/2175
169 12 1/1/169 21/11/2176
170 12 1/1/170 16/11/2177
171 12 1/1/171 11/11/2178
172 12 1/1/172 06/11/2179
173 12 1/1/173 31/10/2180
174 13 1/1/174 26/10/2181
175 12 1/1/175 20/11/2182
176 12 1/1/176 15/11/2183
177 12 1/1/177 09/11/2184
178 12 1/1/178 04/11/2185
179 12 1/1/179 30/10/2186
180 13 1/1/180 25/10/2187
181 12 1/1/181 18/11/2188
182 12 1/1/182 13/11/2189
183 12 1/1/183 08/11/2190
184 12 1/1/184 03/11/2191
185 12 1/1/185 28/10/2192
186 13 1/1/186 23/10/2193
187 12 1/1/187 17/11/2194
188 12 1/1/188 12/11/2195
189 12 1/1/189 06/11/2196
190 12 1/1/190 01/11/2197
191 12 1/1/191 27/10/2198
192 13 1/1/192 22/10/2199
193 12 1/1/193 16/11/2200
194 12 1/1/194 11/11/2201
195 12 1/1/195 06/11/2202
196 12 1/1/196 01/11/2203
197 12 1/1/197 26/10/2204
198 13 1/1/198 21/10/2205
199 12 1/1/199 15/11/2206
200 12 1/1/200 10/11/2207

Code is hidden, SHOW

by **chrissie1** on Sat Jan 31, 2009 6:04 pm

I'm pretty sure it's not every six years since that doesn't account for leap years. It is whenever you have more than 30 days left in a year then you add an extra month.

As you can see your solution is degarading over time. in the end you already have your old year somewhrer in octobre while mine always stays in december.

SO mine is more rigth than yours.

by **earthandfire** on Sun Feb 01, 2009 6:54 am

I agree with George with regard to which years should contain the extra month - the earliest years which can support 390 days should have 390 days.

The following also supports leap years.

tsqlLine number Off | Show | Select all

Code is hidden, SHOW

textLine number Off | Show | Select all

GregDate SimplerYear SimplerStartDate SimplerMonths ExpectedDate TotalLostDays
---------- ----------- ---------------- ------------- ------------ -------------
01/01/2009 1 01/01/1 12 01/01/2009 5
27/12/2009 2 01/01/2 12 01/01/2010 10
22/12/2010 3 01/01/3 12 01/01/2011 15
17/12/2011 4 01/01/4 12 01/01/2012 21
11/12/2012 5 01/01/5 12 01/01/2013 26
05/01/2014 6 01/01/6 13 01/01/2014 1
31/12/2014 7 01/01/7 12 01/01/2015 6
26/12/2015 8 01/01/8 12 01/01/2016 12
20/12/2016 9 01/01/9 12 01/01/2017 17
15/12/2017 10 01/01/10 12 01/01/2018 22
10/12/2018 11 01/01/11 12 01/01/2019 27
04/01/2020 12 01/01/12 13 01/01/2020 3
29/12/2020 13 01/01/13 12 01/01/2021 8
24/12/2021 14 01/01/14 12 01/01/2022 13
19/12/2022 15 01/01/15 12 01/01/2023 18
14/12/2023 16 01/01/16 12 01/01/2024 24
08/12/2024 17 01/01/17 12 01/01/2025 29
02/01/2026 18 01/01/18 13 01/01/2026 4
28/12/2026 19 01/01/19 12 01/01/2027 9
23/12/2027 20 01/01/20 12 01/01/2028 15
17/12/2028 21 01/01/21 12 01/01/2029 20
12/12/2029 22 01/01/22 12 01/01/2030 25
06/01/2031 23 01/01/23 13 01/01/2031 0
01/01/2032 24 01/01/24 12 01/01/2032 6
26/12/2032 25 01/01/25 12 01/01/2033 11
21/12/2033 26 01/01/26 12 01/01/2034 16
16/12/2034 27 01/01/27 12 01/01/2035 21
11/12/2035 28 01/01/28 12 01/01/2036 27
04/01/2037 29 01/01/29 13 01/01/2037 2
30/12/2037 30 01/01/30 12 01/01/2038 7
25/12/2038 31 01/01/31 12 01/01/2039 12
20/12/2039 32 01/01/32 12 01/01/2040 18
14/12/2040 33 01/01/33 12 01/01/2041 23
09/12/2041 34 01/01/34 12 01/01/2042 28
03/01/2043 35 01/01/35 13 01/01/2043 3
29/12/2043 36 01/01/36 12 01/01/2044 9
23/12/2044 37 01/01/37 12 01/01/2045 14
18/12/2045 38 01/01/38 12 01/01/2046 19
13/12/2046 39 01/01/39 12 01/01/2047 24
07/01/2048 40 01/01/40 13 01/01/2048 0
01/01/2049 41 01/01/41 12 01/01/2049 5
27/12/2049 42 01/01/42 12 01/01/2050 10
22/12/2050 43 01/01/43 12 01/01/2051 15
17/12/2051 44 01/01/44 12 01/01/2052 21
11/12/2052 45 01/01/45 12 01/01/2053 26
05/01/2054 46 01/01/46 13 01/01/2054 1
31/12/2054 47 01/01/47 12 01/01/2055 6
26/12/2055 48 01/01/48 12 01/01/2056 12
20/12/2056 49 01/01/49 12 01/01/2057 17
15/12/2057 50 01/01/50 12 01/01/2058 22
10/12/2058 51 01/01/51 12 01/01/2059 27
04/01/2060 52 01/01/52 13 01/01/2060 3
29/12/2060 53 01/01/53 12 01/01/2061 8
24/12/2061 54 01/01/54 12 01/01/2062 13
19/12/2062 55 01/01/55 12 01/01/2063 18
14/12/2063 56 01/01/56 12 01/01/2064 24
08/12/2064 57 01/01/57 12 01/01/2065 29
02/01/2066 58 01/01/58 13 01/01/2066 4
28/12/2066 59 01/01/59 12 01/01/2067 9
23/12/2067 60 01/01/60 12 01/01/2068 15
17/12/2068 61 01/01/61 12 01/01/2069 20
12/12/2069 62 01/01/62 12 01/01/2070 25
06/01/2071 63 01/01/63 13 01/01/2071 0
01/01/2072 64 01/01/64 12 01/01/2072 6
26/12/2072 65 01/01/65 12 01/01/2073 11
21/12/2073 66 01/01/66 12 01/01/2074 16
16/12/2074 67 01/01/67 12 01/01/2075 21
11/12/2075 68 01/01/68 12 01/01/2076 27
04/01/2077 69 01/01/69 13 01/01/2077 2
30/12/2077 70 01/01/70 12 01/01/2078 7
25/12/2078 71 01/01/71 12 01/01/2079 12
20/12/2079 72 01/01/72 12 01/01/2080 18
14/12/2080 73 01/01/73 12 01/01/2081 23
09/12/2081 74 01/01/74 12 01/01/2082 28
03/01/2083 75 01/01/75 13 01/01/2083 3
29/12/2083 76 01/01/76 12 01/01/2084 9
23/12/2084 77 01/01/77 12 01/01/2085 14
18/12/2085 78 01/01/78 12 01/01/2086 19
13/12/2086 79 01/01/79 12 01/01/2087 24
07/01/2088 80 01/01/80 13 01/01/2088 0
01/01/2089 81 01/01/81 12 01/01/2089 5
27/12/2089 82 01/01/82 12 01/01/2090 10
22/12/2090 83 01/01/83 12 01/01/2091 15
17/12/2091 84 01/01/84 12 01/01/2092 21
11/12/2092 85 01/01/85 12 01/01/2093 26
05/01/2094 86 01/01/86 13 01/01/2094 1
31/12/2094 87 01/01/87 12 01/01/2095 6
26/12/2095 88 01/01/88 12 01/01/2096 12
20/12/2096 89 01/01/89 12 01/01/2097 17
15/12/2097 90 01/01/90 12 01/01/2098 22
10/12/2098 91 01/01/91 12 01/01/2099 27
04/01/2100 92 01/01/92 13 01/01/2100 2
30/12/2100 93 01/01/93 12 01/01/2101 7
25/12/2101 94 01/01/94 12 01/01/2102 12
20/12/2102 95 01/01/95 12 01/01/2103 17
15/12/2103 96 01/01/96 12 01/01/2104 23
09/12/2104 97 01/01/97 12 01/01/2105 28
03/01/2106 98 01/01/98 13 01/01/2106 3
29/12/2106 99 01/01/99 12 01/01/2107 8
24/12/2107 100 01/01/100 12 01/01/2108 14

Code is hidden, SHOW

by **chrissie1** on Sun Feb 01, 2009 9:50 am

I agree with both points of view. I think the point was that the new calendar should keep in sink more or less with the older calendar so when you add the extra month is open to some debate. But I guess your interpretation would cause even less degradation of the seasons.

Georges solution was a bit flawed because it was degrading to a point where the simple calendars newyear would be in octobre. Mine always fell in december. And E&F is either in january or december.

But am I the only one that is using a sensible programming language?

by **earthandfire** on Sun Feb 01, 2009 12:07 pm

A VB Solution just for Chrissie

vbnetLine number Off | Show | Select all

Code is hidden, SHOW

textLine number Off | Show | Select all

SimplerYear MonthsInYear ExpectedStartDate ActualStartDate LostDays
===================================================================
1 12 01/01/2009 01/01/2009 5
2 12 01/01/2010 27/12/2009 10
3 12 01/01/2011 22/12/2010 15
4 12 01/01/2012 17/12/2011 21
5 12 01/01/2013 11/12/2012 26
6 13 01/01/2014 05/01/2014 1
7 12 01/01/2015 31/12/2014 6
8 12 01/01/2016 26/12/2015 12
9 12 01/01/2017 20/12/2016 17
10 12 01/01/2018 15/12/2017 22
11 12 01/01/2019 10/12/2018 27
12 13 01/01/2020 04/01/2020 3
13 12 01/01/2021 29/12/2020 8
14 12 01/01/2022 24/12/2021 13
15 12 01/01/2023 19/12/2022 18
16 12 01/01/2024 14/12/2023 24
17 12 01/01/2025 08/12/2024 29
18 13 01/01/2026 02/01/2026 4
19 12 01/01/2027 28/12/2026 9
20 12 01/01/2028 23/12/2027 15
21 12 01/01/2029 17/12/2028 20
22 12 01/01/2030 12/12/2029 25
23 13 01/01/2031 06/01/2031 0
24 12 01/01/2032 01/01/2032 6
25 12 01/01/2033 26/12/2032 11
26 12 01/01/2034 21/12/2033 16
27 12 01/01/2035 16/12/2034 21
28 12 01/01/2036 11/12/2035 27
29 13 01/01/2037 04/01/2037 2
30 12 01/01/2038 30/12/2037 7
31 12 01/01/2039 25/12/2038 12
32 12 01/01/2040 20/12/2039 18
33 12 01/01/2041 14/12/2040 23
34 12 01/01/2042 09/12/2041 28
35 13 01/01/2043 03/01/2043 3
36 12 01/01/2044 29/12/2043 9
37 12 01/01/2045 23/12/2044 14
38 12 01/01/2046 18/12/2045 19
39 12 01/01/2047 13/12/2046 24
40 13 01/01/2048 07/01/2048 0
41 12 01/01/2049 01/01/2049 5
42 12 01/01/2050 27/12/2049 10
43 12 01/01/2051 22/12/2050 15
44 12 01/01/2052 17/12/2051 21
45 12 01/01/2053 11/12/2052 26
46 13 01/01/2054 05/01/2054 1
47 12 01/01/2055 31/12/2054 6
48 12 01/01/2056 26/12/2055 12
49 12 01/01/2057 20/12/2056 17
50 12 01/01/2058 15/12/2057 22
51 12 01/01/2059 10/12/2058 27
52 13 01/01/2060 04/01/2060 3
53 12 01/01/2061 29/12/2060 8
54 12 01/01/2062 24/12/2061 13
55 12 01/01/2063 19/12/2062 18
56 12 01/01/2064 14/12/2063 24
57 12 01/01/2065 08/12/2064 29
58 13 01/01/2066 02/01/2066 4
59 12 01/01/2067 28/12/2066 9
60 12 01/01/2068 23/12/2067 15
61 12 01/01/2069 17/12/2068 20
62 12 01/01/2070 12/12/2069 25
63 13 01/01/2071 06/01/2071 0
64 12 01/01/2072 01/01/2072 6
65 12 01/01/2073 26/12/2072 11
66 12 01/01/2074 21/12/2073 16
67 12 01/01/2075 16/12/2074 21
68 12 01/01/2076 11/12/2075 27
69 13 01/01/2077 04/01/2077 2
70 12 01/01/2078 30/12/2077 7
71 12 01/01/2079 25/12/2078 12
72 12 01/01/2080 20/12/2079 18
73 12 01/01/2081 14/12/2080 23
74 12 01/01/2082 09/12/2081 28
75 13 01/01/2083 03/01/2083 3
76 12 01/01/2084 29/12/2083 9
77 12 01/01/2085 23/12/2084 14
78 12 01/01/2086 18/12/2085 19
79 12 01/01/2087 13/12/2086 24
80 13 01/01/2088 07/01/2088 0
81 12 01/01/2089 01/01/2089 5
82 12 01/01/2090 27/12/2089 10
83 12 01/01/2091 22/12/2090 15
84 12 01/01/2092 17/12/2091 21
85 12 01/01/2093 11/12/2092 26
86 13 01/01/2094 05/01/2094 1
87 12 01/01/2095 31/12/2094 6
88 12 01/01/2096 26/12/2095 12
89 12 01/01/2097 20/12/2096 17
90 12 01/01/2098 15/12/2097 22
91 12 01/01/2099 10/12/2098 27
92 13 01/01/2100 04/01/2100 2
93 12 01/01/2101 30/12/2100 7
94 12 01/01/2102 25/12/2101 12
95 12 01/01/2103 20/12/2102 17
96 12 01/01/2104 15/12/2103 23
97 12 01/01/2105 09/12/2104 28
98 13 01/01/2106 03/01/2106 3
99 12 01/01/2107 29/12/2106 8
100 12 01/01/2108 24/12/2107 14

Code is hidden, SHOW

by **chrissie1** on Sun Feb 01, 2009 12:14 pm

Not bad.

by **earthandfire** on Sun Feb 01, 2009 1:05 pm

I take that from you, Chrissie, as a compliment - thank you!

by **chrissie1** on Sun Feb 01, 2009 2:33 pm

earthandfire wrote:I take that from you, Chrissie, as a compliment - thank you!

I aim to please.

LessThanDot

Forum Search

Highly Rated Users

Forum Statistics

Other

Google Ads

LTD Puzzle 20: A simpler calendar

LTD Puzzle 20: A simpler calendar

Re: LTD Puzzle 20: A simpler calendar

Re: LTD Puzzle 20: A simpler calendar

Re: LTD Puzzle 20: A simpler calendar

Re: LTD Puzzle 20: A simpler calendar

Re: LTD Puzzle 20: A simpler calendar

Re: LTD Puzzle 20: A simpler calendar

Re: LTD Puzzle 20: A simpler calendar

Re: LTD Puzzle 20: A simpler calendar

Re: LTD Puzzle 20: A simpler calendar

Re: LTD Puzzle 20: A simpler calendar

Re: LTD Puzzle 20: A simpler calendar

Re: LTD Puzzle 20: A simpler calendar

LessThanDot

LTD Social Sitings

Forum Search

Highly Rated Users

Forum Statistics

Other

Google Ads