Comments 11Issac started the conversationFebruary 28, 2017 at 7:53pmHello,I use the date column and it is messed up (see attachment), the date becomes 01/01/1970 for some of the rows while the others are fine.Also, the date format is dd/mm/yyyy but I want it to be mm/dd/yyyy, how can I change that? Thanks in advance! 11Issac repliedFebruary 28, 2017 at 8:57pmAlso, I realize that the additional variable "varInput" is eating up all the space in the text (see attachment). Can you also look into it as well? Thanks![deleted] repliedMarch 1, 2017 at 12:45pmHi issacchua,Thank you for the purchase.1. Can you please send me a link of the table so I can take a look?2. About Variables issue, what version of the Report Builder do you have? Issac replied privately[deleted] repliedMarch 2, 2017 at 2:57pmHi issacchua,Can you give me permission so I can edit wpDataTables plugin also? I have to take a look at the table with ID 75?PRIVATE TICKET #1078230- This ticket is assigned to another support agent and he'll reply you as soon he see the ticket. Issac replied privately[deleted] repliedMarch 3, 2017 at 1:51pmHi issacchua,I still can't see wpDataTables in the left menu. Can you please check? 11Issac repliedMarch 3, 2017 at 4:37pmOh... You mean that... The wpdatatables is inside the settings tab :)[deleted] repliedMarch 6, 2017 at 3:20pmHi issacchua,Can you please send me the dump of the lQjbFlOlwpdatatable_7 table from the database so I could reproduce the issue at my local and try to fix it?[deleted] repliedMarch 6, 2017 at 3:53pmHi issacchua,This issue is fixed. Next time when you update the wpDataTables plugin please find in file class.date.wpdatacolumn.php and in it find: $timestamp = is_numeric( $content ) ? $content : strtotime( str_replace('/', '-', $content ) );and replace it with: $timestamp = is_numeric( $content ) ? $content : strpos( $content, '/' ) ? strtotime( $content ) : strtotime( str_replace('/', '-', $content ) ); 11Issac repliedMarch 7, 2017 at 7:10amI see that you have fixed the issue! Thank you so much!!![deleted] repliedMarch 7, 2017 at 2:29pmHi issacchua,You are welcome. We'd greatly appreciate it if you could take a minute and leave a review on CodeCanyon on this link. Thanks! 11Issac repliedMarch 7, 2017 at 8:54pmAlready did. Thank you for your support!1 Like Sign in to reply ...
Hello,
I use the date column and it is messed up (see attachment), the date becomes 01/01/1970 for some of the rows while the others are fine.
Also, the date format is dd/mm/yyyy but I want it to be mm/dd/yyyy, how can I change that?
Thanks in advance!
Also, I realize that the additional variable "varInput" is eating up all the space in the text (see attachment). Can you also look into it as well? Thanks!
Hi issacchua,
Thank you for the purchase.
1. Can you please send me a link of the table so I can take a look?
2. About Variables issue, what version of the Report Builder do you have?
Hi issacchua,
Can you give me permission so I can edit wpDataTables plugin also? I have to take a look at the table with ID 75?
PRIVATE TICKET #1078230
- This ticket is assigned to another support agent and he'll reply you as soon he see the ticket.
Hi issacchua,
I still can't see wpDataTables in the left menu. Can you please check?
Oh... You mean that... The wpdatatables is inside the settings tab :)
Hi issacchua,
Can you please send me the dump of the lQjbFlOlwpdatatable_7 table from the database so I could reproduce the issue at my local and try to fix it?
Hi issacchua,
This issue is fixed. Next time when you update the wpDataTables plugin please find in file class.date.wpdatacolumn.php and in it find:
$timestamp = is_numeric( $content ) ? $content : strtotime( str_replace('/', '-', $content ) );and replace it with:
$timestamp = is_numeric( $content ) ? $content : strpos( $content, '/' ) ? strtotime( $content ) : strtotime( str_replace('/', '-', $content ) );I see that you have fixed the issue! Thank you so much!!!
Hi issacchua,
You are welcome. We'd greatly appreciate it if you could take a minute and leave a review on CodeCanyon on this link. Thanks!
Already did. Thank you for your support!