Answers

• allan Posts: 63,353Questions: 1Answers: 10,444 Site admin

  May 2016

  Hi Rappi,

  I was going to suggest basically what you have done - to an if condition to see if the date is valid or not. If that isn't working, I would need a link to a page showing that issue so I can debug it.

  Thanks,
  Allan
• Rappi Posts: 82Questions: 18Answers: 1

  May 2016

  Hi Allan.

  It's not an open system.
  You can insert this URL

  http://www.rappi.de/Tier-Management/modules/Mitglieds-Management/mitglieder.php

  login with demo/demo and insert the URL again.

  Than you See the Problem in the col "Geburtsdatum".

  Rappi
• allan Posts: 63,353Questions: 1Answers: 10,444 Site admin

  May 2016 Answer ✓

  The error is var rowvalueallday = row["5"];. Just use the data parameter passed in since that already points to the tm_mm_mitglieder.Geburtsdatum data!

  The issue with row['5'] is that there is no 5 data property in your data source object.

  Allan
• Rappi Posts: 82Questions: 18Answers: 1

  May 2016

  Thanks for your answer.

  Now I have

  data: "tm_mm_mitglieder.Geburtsdatum",
                  render: function ( data, type, row ) {
                      var rowvalueallday =row["tm_mm_mitglieder.Geburtsdatum"];
                      
                        if (rowvalueallday == '0000-00-00') {
                          var gdat = '1900-01-01';
                          return gdat;
                        } else {
                          return (moment(data).format("DD.MM.YYYY"));
                        }       
                         
                  }
  

  Same error :-(

  I think, the moment convert the data before gdat returns and have a problem with a date like 0000-00-00.

  Another idea?

  Rappi
• Rappi Posts: 82Questions: 18Answers: 1

  May 2016

  I have played with but no solution found :-(

  data: "tm_mm_mitglieder.Geburtsdatum",
                  render: function ( data, type, row ) {
                      var rowvalueallday = row['tm_mm_mitglieder.Geburtsdatum'];
                      
                        if (rowvalueallday == '0000-00-00') {
                          var gdat = '1900-01-01';
                          return (moment(gdat).format("DD.MM.YYYY"));
                        } else {
                          return (moment(data).format("DD.MM.YYYY"));
                        }       
                         
                  }
  

  Now I don't have an idea.....
• allan Posts: 63,353Questions: 1Answers: 10,444 Site admin

  May 2016 Answer ✓

  row['tm_mm_mitglieder.Geburtsdatum'];

  That is not correct. It is a Javascript object, so you would use:

  row.tm_mm_mitglieder.Geburtsdatum;
  

  or just use the data parameter as I suggested above.

  Allan
• Rappi Posts: 82Questions: 18Answers: 1

  May 2016

  You are my hero (again) :-D

  Thanks!

  PHP is my world but JS ...... Umpff

  Rappi
• Watchara Posts: 30Questions: 5Answers: 1

  September 2016 edited September 2016

  I had followed by your solution it working to render date time.

  but it's not working to sorting date.

  What should I do? or Mr.Rappi Could you please help me?

  Watchara.
• allan Posts: 63,353Questions: 1Answers: 10,444 Site admin

  September 2016

  @Watchara - Please link to a test case showing the issue.