Skip to Content
This question has been flagged
6 Replies
18091 Views
Avatar
Undan

When two dates are given for eg: start date-: 05/01/2016 end date : 05/03/2016 ..from january to march ..i want to display all the dates between these two dates.

Avatar
Discard
Avatar
Anil Kesariya
Best Answer

Undan,

Here you Go!

import datetime
t_date = datetime.datetime.today()
num_of_day = 10 # This is different between two date range, you just find difference and use as numb_of_day
date_list = [base - datetime.timedelta(days=x) for x in range(0, num_of_day)]
print "Day List in Datetime Format:",date_list

This might help you,

Regards,

Anil.

Avatar
Discard
Avatar
iWesabe Technologies
Best Answer 




def dates_between_str_dates(self, date1, date2, mode='date'):
    date_from = fields.Date.from_string(date1)
    date_to = fields.Date.from_string(date2)
    
    delta = date_to - date_from

    if delta.days < 0: 
        return None 
    
    res = []
    
    for n in range(delta.days + 1): 
       if mode == 'date': 
           res.append(date_from + timedelta(days=n)) 
       if mode == 'string':
           res.append(fields.Date.to_string(date_from + timedelta(days=n))) 
    return res 

Add this function. Parameter mode is to specify output type string/date.   

Thanks !

iWesabe

Avatar
Discard
Linita Abraham

hi, in XML report, how can I display all the dates in that range(start_date to end_date)?

iWesabe Technologies

You can call python function from Qweb Like ..

<tr t-foreach="o.dates_between_str_dates(o.date_from,o.date_to)" t-as="each_date">

Linita Abraham

Thank you so much..This was so helpful.

Linita Abraham

Hi, any idea how to display net sales for each day in the report

orders = self.env['pos.order'].search([('date_order', '>=', docs.date_from),

('date_order', '<=', docs.date_to)])

for order in orders:

net_sales += order.amount_total

but in xml report,for me it is displaying the total net sales of that range in all dates of that range,but i want to display net_sales per date.How can i display net sales per date?

Thanks in advance

Avatar
Deepak
Best Answer 
 
fmt = '%Y-%m-%d'
d1 = datetime.strptime(from_date, fmt)
d2 = datetime.strptime(to_date, fmt)
dates_btwn = d1
while dates_btwn <= d2:    
    print "dates_between=========>>>",dates_btwn.date()
    dates_btwn = dates_btwn + relativedelta.relativedelta(days=1) 

This will display the dates between two dates..Hope this will help You..

Avatar
Discard
Avatar
Tarek Mohamed Ibrahim
Best Answer

use the following function, it is based on using the 'timedelta' 


from datetime import datetime, timedelta

#show dates between two dates

def get_date_list(date1, date2):

    date_list = []

    loop_dt = date1

    print loop_dt

    while loop_dt < date2:

        loop_dt = loop_dt + timedelta(days=1)

        print loop_dt


get_date_list( datetime(2016,1,5), datetime(2016,03,5))


you can change it to return a list of dates

Avatar
Discard
Avatar
Hetashree Chauhan (hch)
Best Answer

import datetime

today = datetime.datetime.today()

numdays = 10

date_list = [today - datetime.timedelta(days=x) for x in range(0, numdays)]

print 'date_list',date_list

Avatar
Discard
Avatar
Neha Patel (nat)
Best Answer

from datetime import date, timedelta as td

dt1 = date(2016, 7, 10)

dt2 = date(2016, 7, 19)

delta = dt2 - dt1

for i in range(delta.days + 1):

    print dt1 + td(days=i)



i hope it might help you

Avatar
Discard