Hello, I am creating a report for point of sale to get the total refunds made in a day, and so i queried the table account_bank_statement_line to get the amount, but the date for the refunds i.e Order 137667889 REFUND shows a date i.e 2014-01-20 and yet the that it was created was today i.e 2014-01-24, the date for other Orders i.e Order 137667889 is ok, So is there a bug on how the current date is not being captured by the refunds? the create_date and write_date are ok, its only the date column that is wrong, so it means if i want to get the refunds for a day, i wont get it since it will be having a date that is not for today.

Below is The query and the output

SELECT id,create_date,write_date,date,ref,amount
  FROM account_bank_statement_line where ref like '%%REFUND' order by id desc;

Output

id      |create_date        |write_date    |date    |ref       |   amount
7201;"2014-01-22 12:17:39.57431";"2014-01-22 14:24:26.828939";"2014-01-20";"Order 1390385908531 REFUND";-1200.00
7144;"2014-01-22 08:36:24.819073";"2014-01-22 14:24:26.828939";"2014-01-20";"Order 1390378507908 REFUND";-4000.00
7134;"2014-01-22 08:10:08.37137";"2014-01-22 14:24:26.828939";"2014-01-20";"Order 1390369891636 REFUND";-3500.00
7104;"2014-01-22 06:22:18.093536";"2014-01-22 14:24:26.828939";"2014-01-20";"Order 1390208029693 REFUND";-3600.00