[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: ERROR: date/time field value out of range: "31/10/2014"



A temp fix would be to change your date format to yyyy-mm-dd and enter the date in that format.

On Sun, Nov 2, 2014 at 10:05 PM, Max van Biezen <..hidden..> wrote:
Hi

Would there a temp. fix possible by changing something in the DB? I
made a stupid mistake entering data and I have quite a few entries I
would like to reverse. Though the mistake is not that bad I dare to
take risks.

Max

On 3 November 2014 02:08, Chris Travers <..hidden..> wrote:
>
>
>>
>> DBD::Pg::st execute failed: ERROR:  date/time field value out of
>> range: "31/10/2014"
>> LINE 1: SELECT * FROM "public"."payment__reverse"(NULL, '31/10/2014'...
>>
>
> I will file a bug report on this.  If anyone else wants to take a crack at
> it, the problem is probably that we aren't telling LSMB it is a dae field.
> I.e. we need to identify the fieldname involved and then add a
> $request->dates('fieldname') or $request->dates_series(1,
> $request->{rowcount}, 'fieldname') as appropriate.
>
>>

------------------------------------------------------------------------------
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users



--
Best Wishes,
Chris Travers

Efficito:  Hosted Accounting and ERP.  Robust and Flexible.  No vendor lock-in.
http://www.efficito.com/learn_more
------------------------------------------------------------------------------
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users