def single_month_end(month, year, col_tag):
tag_label = '%s %d' % (MONTHS[month-1], year)
end_of_this_month = datefuncs.end_of_month(month,year)
end_of_prev_month = datefuncs.end_of_prev_month(month,year)
columns = [end_of_prev_month.isoformat(), col_tag, end_of_this_month.isoformat()]
column_titles = [end_of_prev_month.isoformat(), tag_label, end_of_this_month.isoformat()]
return columns, column_titles
def trailing_monthly_ends(dt):
next_month = datefuncs.start_of_next_month(dt)
start = datetime.date(dt.year-1,dt.month,1)
finish = dt
months = list(datefuncs.monthrange(start, finish))
columns = [datefuncs.end_of_month(x[1],x[0]).isoformat() for x in months]
column_titles = columns
return columns, column_titles
def multiyear_ends(dt, years):
start = datefuncs.start_of_month(dt.month, dt.year)
finish = datetime.date(start.year + years, start.month, start.day)
months = list(datefuncs.monthrange(start, finish))
columns = [datefuncs.end_of_month(x[1],x[0]).isoformat() for x in months]
column_titles = columns
return columns, column_titles
def multiyear_ends(dt, years):
start = datefuncs.start_of_month(dt.month, dt.year)
finish = datetime.date(start.year + years, start.month, start.day)
months = list(datefuncs.monthrange(start, finish))
columns = [datefuncs.end_of_month(x[1], x[0]).isoformat() for x in months]
column_titles = columns
return columns, column_titles
def trailing_monthly_ends(dt):
next_month = datefuncs.start_of_next_month(dt)
start = datetime.date(dt.year - 1, dt.month, 1)
finish = dt
months = list(datefuncs.monthrange(start, finish))
columns = [datefuncs.end_of_month(x[1], x[0]).isoformat() for x in months]
column_titles = columns
return columns, column_titles
def single_month_end(month, year, col_tag):
tag_label = '%s %d' % (MONTHS[month - 1], year)
end_of_this_month = datefuncs.end_of_month(month, year)
end_of_prev_month = datefuncs.end_of_prev_month(month, year)
columns = [
end_of_prev_month.isoformat(), col_tag,
end_of_this_month.isoformat()
]
column_titles = [
end_of_prev_month.isoformat(), tag_label,
end_of_this_month.isoformat()
]
return columns, column_titles
