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!
Please register and login to view forums and other content only available to registered users.
Please register and login to view forums and other content only available to registered users.
Date shows Nov-30-1999 when db value is 0000-00-00 00:00
-
- Posts: 79
- Joined: Thu Oct 20, 2011 9:13 pm
-
- 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.