Hi
I'm working with a report in RML, and data table of pos_order.
Using date_order field is set to 'timestamp' format.
Use the following format for the day, month, year:
datetime.datetime.strptime(pos_order.date_order, DEFAULT_SERVER_DATE_FORMAT).strftime('%d/%m/%Y')
but without result.
Another solution?
Thank You.
This is a snippet of my code:
report.py
def get_pos_data(self, form):
pos_order_obj = self.pool.get('pos.order')
pos_order_id = pos_order_obj.search(self.cr, self.uid, [
('date_order','>=', period.date_start),
('date_order','<=', period.date_stop)])
pos_order_list = []
for pos_order in pos_order_obj.browse(self.cr, self.uid, pos_order_id):
res = {
'date_pos' : time.strftime('%d') + '-' + datetime.strptime(pos_order.date_order, '%d-%m-%Y').strftime('%b').upper() + '-' + time.strftime('%Y')
}
pos_order_list.append(res)
return pos_order_list
report.rml
<para style="P4">[[ obj['date_pos'] ]]</para>