Hi,
I am using version v2.8.1-12.12.19-Build554.
When I use a text object with date formatting, the fields in my database withe the value: '0000-00-00 00:00', are displayed as 'Nov-30-1999' in nuBuilder's edit form.
I solved this by changing line 485 of common.php file from:
if($pValue=='' or $pValue=='0000-00-00'){
to:
if($pValue=='' or $pValue=='0000-00-00' or $pValue=='0000-00-00 00:00'){
Hope this helps someone else.
Regrads!
Fike
Welcome to the nuBuilder Forums!
Join our community by registering and logging in.
As a member, you'll get access to exclusive forums, resources, and content available only to registered users.
Join our community by registering and logging in.
As a member, you'll get access to exclusive forums, resources, and content available only to registered users.
Date shows Nov-30-1999 when db value is 0000-00-00 00:00
-
Fike
- Posts: 79
- Joined: Thu Oct 20, 2011 9:13 pm
-
massiws
- Posts: 503
- Joined: Thu May 24, 2012 2:08 am
- Location: Milan, Italy
- Contact:
Re: Date shows Nov-30-1999 when db value is 0000-00-00 00:00
Fike, you are right!
It only happens if MySQL field Type is DATETIME; if you don't need the time information you can set the MySQL field Type to DATE.
Thanks to report this.
It only happens if MySQL field Type is DATETIME; if you don't need the time information you can set the MySQL field Type to DATE.
Thanks to report this.