Date shows Nov-30-1999 when db value is 0000-00-00 00:00

[Fike]

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

[massiws]

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.