def multiyear_periods(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 = ['%sM%s' % (x[0], '%02d' % x[1]) for x in months]
    column_titles = columns

    return columns, column_titles
def trailing_monthly_periods(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 = ['%sM%s' % (x[0], '%02d' % x[1]) 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 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
Exemple #5
0
def trailing_monthly_periods(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 = ['%sM%s' % (x[0], '%02d' % x[1]) for x in months]
    column_titles = columns

    return columns, column_titles
Exemple #6
0
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
Exemple #7
0
def multiyear_periods(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 = ['%sM%s' % (x[0], '%02d' % x[1]) for x in months]
    column_titles = columns

    return columns, column_titles
Exemple #8
0
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