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

[Pongrácz István <..hidden..>]

Hi,

A quick workaround could be: change the date format to an other one and try that.
'YYYY-MM-DD' could be good starting point.

Cheers,
István 


----------------eredeti üzenet-----------------
Feladó: "Max van Biezen" ..hidden.. 
Címzett: ..hidden.. 
Dátum: Sun, 2 Nov 2014 20:50:59 +0100
-------------------------------------------------
 
 
> Hi,
> 
> I want to execute an entry via cash/vouchers/reverse receipt. It fails
> complaining about the date format. I am running 1.4.6RC2. How to tell
> ledgersmb the date field is okay?
> 
> Max
> 
> 
> 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'...
> ^
> HINT: Perhaps you need a different "datestyle" setting. at
> LedgerSMB.pm line 585.
> 2014/11/02 20:46:30 - ERROR - LedgerSMB::dberror LedgerSMB.pm (772) --
> Logging SQL State 22008, error 7, string ERROR: date/time field value
> out of range: "31/10/2014"
> LINE 1: SELECT * FROM "public"."payment__reverse"(NULL, '31/10/2014'...
> ^
> HINT: Perhaps you need a different "datestyle" setting.
> 2014/11/02 20:46:30 - ERROR - LedgerSMB::_error LedgerSMB.pm (649) --
> Invalid date/time entered
> More information has been reported in the error logs at LedgerSMB.pm line 775.
> 2014/11/02 20:46:30 - ERROR - LedgerSMB::_error LedgerSMB.pm (650) --
> dbversion: 1.4.6, company: <DB-name>
> Died at LedgerSMB.pm line 663.
> Compilation failed in require at /usr/local/lsmb14/payment.pl line 8.
> 
> 
> --------------------------------------------------------------------
> ----------
> _______________________________________________
> Ledger-smb-users mailing list
> ..hidden.. 
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
> 



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