hi i want to addition in date in odoo directives in odoov8
in reports i print invoice date using
now i want to add days in this date meansmy invoice date is 10/01/2015 and my pament term days is 15 so i want to add 15 days in date in report.xml file through qweb directives so output is 10/16/2015 (10/01/2015(mm/dd/yyyy) + 15days = 10/16/2015)
i get payment term days from this
<tr t-foreach="o.payment_term.line_ids" t-as="pl">
<td> <span t-field="pl.days"/> </td>
so how can i do addition in date in qweb directives
i have solved it with this line of codes. In my example i had adapted the report_saleorder.xml.
<span t-set="d_delta" t-value="datetime.timedelta(days=17)"/>
<span t-set="d_dateorder" t-value="datetime.datetime.strptime(doc.date_order,'%Y-%m-%d %H:%M:%S')"/>
<span t-set="d_paydate" t-value="d_dateorder + d_delta"/>
To use the datetime object you have to import the datetime object. --> from datetime import datetime, timedelta this i have added to sale_report.py.
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 10/12/15, 9:14 AM|
|Seen: 1293 times|
|Last updated: 10/13/15, 2:42 AM|