Hey there, Awesome Customers!

Just a heads up: We'll be taking a breather to celebrate International Workers' Day (May 1st and 2nd - Wednesday and Thursday) and Orthodox Easter from Good Friday (May 3rd) through Easter Monday (May 6th). So, from May 1st to May 6th, our team will be off enjoying some well-deserved downtime.

During this time, our customer support will be running on a smaller crew, but don't worry! We'll still be around to help with any urgent matters, though it might take us a bit longer than usual to get back to you.

We'll be back in action at full throttle on May 7th (Tuesday), ready to tackle your questions and requests with gusto!

In the meantime, you can explore our documentation for Amelia and wpDataTables. You'll find loads of helpful resources, including articles and handy video tutorials on YouTube (Amelia's YouTube Channel and wpDataTables' YouTube Channel). These gems might just have the answers you're looking for while we're kicking back.

Thanks a bunch for your understanding and support!

Catch you on the flip side!

Warm regards,

TMS

Okay
  Public Ticket #1079221
Date is messed up in the report
Closed

Comments

  •  11
    Issac started the conversation
    February 28, 2017 at 7:53pm

    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!

  •  11
    Issac replied
    February 28, 2017 at 8:57pm

    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!

  • [deleted] replied
    March 1, 2017 at 12:45pm

    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?

  •   Issac replied privately
  • [deleted] replied
    March 2, 2017 at 2:57pm

    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.


  •   Issac replied privately
  • [deleted] replied
    March 3, 2017 at 1:51pm

    Hi issacchua,

    I still can't see wpDataTables in the left menu. Can you please check?

  •  11
    Issac replied
    March 3, 2017 at 4:37pm

    Oh... You mean that... The wpdatatables is inside the settings tab :)

  • [deleted] replied
    March 6, 2017 at 3:20pm

    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?

  • [deleted] replied
    March 6, 2017 at 3:53pm

    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 ) );


  •  11
    Issac replied
    March 7, 2017 at 7:10am

    I see that you have fixed the issue! Thank you so much!!!

  • [deleted] replied
    March 7, 2017 at 2:29pm

    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! 

  •  11
    Issac replied
    March 7, 2017 at 8:54pm

    Already did. Thank you for your support!