You can use pandas.date_range() for this: import pandas pandas.date_range(sdate,edate-timedelta(days=1),freq=’d’) DatetimeIndex([‘2019-03-22’, ‘2019-03-23’, ‘2019-03-24’, ‘2019-03-25’, ‘2019-03-26’, ‘2019-03-27’, ‘2019-03-28’, ‘2019-03-29’, ‘2019-03-30’, ‘2019-03-31’, ‘2019-04-01’, ‘2019-04-02’, ‘2019-04-03’, ‘2019-04-04’, ‘2019-04-05’, ‘2019-04-06’, ‘2019-04-07’, ‘2019-04-08′], dtype=”datetime64[ns]”, freq=’D’)
You can do this by changing the freq argument from ‘M’ to ‘MS’: d = pandas.date_range(start=”1/1/1980″, end=’11/1/1990′, freq=’MS’) print(d) This should now print: DatetimeIndex([‘1980-01-01’, ‘1980-02-01’, ‘1980-03-01’, ‘1980-04-01’, ‘1980-05-01’, ‘1980-06-01’, ‘1980-07-01’, ‘1980-08-01’, ‘1980-09-01’, ‘1980-10-01’, … ‘1990-02-01’, ‘1990-03-01’, ‘1990-04-01’, ‘1990-05-01’, ‘1990-06-01’, ‘1990-07-01’, ‘1990-08-01’, ‘1990-09-01’, ‘1990-10-01’, ‘1990-11-01′], dtype=”datetime64[ns]”, length=131, freq=’MS’, tz=None) Look into the offset aliases part of … Read more
This is where DAO shines. It is so much faster to run a loop adding records than calling a Insert Into multiple times. Here is how: Public Function PopulateBokings() Dim rsBookings As DAO.Recordset Dim NextDate As Date Set rsBookings = CurrentDb.OpenRecordset(“Select Top 1 * From Bookings”) NextDate = Me!StartDate.Value While DateDiff(“d”, NextDate, Me!EndDate.Value) >= 0 … Read more
This solution doesn’t require you to hard-code the list of months you might want, all you need to do is provide any start date and any end date, and it will calculate the month boundaries for you. It includes year in the output so that it will support more than 12 months and so that … Read more
No, you didn’t miss a general purpose class. I have a Range type in MiscUtil which you may be interested in – and it certainly makes for simple DateTime manipulation. Referring to Marc’s answer, I can’t remember whether this is a struct or a class – you’d be welcome to change it of course. It’s … Read more
Here’s a way to do it by making use of the way adding one day causes the date to roll over to the next month if necessary, and without messing around with milliseconds. Daylight savings aren’t an issue either. var now = new Date(); var daysOfYear = []; for (var d = new Date(2012, 0, … Read more
left join two tables with a where condition It’s typically wrong to use a LEFT [OUTER] JOIN and then filter with a WHERE condition, thereby voiding the special feature of a LEFT JOIN to include all rows from the left table unconditionally. Detailed explanation: Explain JOIN vs. LEFT JOIN and WHERE condition performance suggestion in … Read more
Here you go: DECLARE @DateFrom smalldatetime, @DateTo smalldatetime; SET @DateFrom=’20000101′; SET @DateTo=’20081231′; ——————————- WITH T(date) AS ( SELECT @DateFrom UNION ALL SELECT DateAdd(day,1,T.date) FROM T WHERE T.date < @DateTo ) SELECT date FROM T OPTION (MAXRECURSION 32767);