We're Moving to a New Support Platform – Starting June 1st!

We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – AmeliawpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.

You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.

While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.

We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.

Thanks for your continued support and trust – we’re excited to bring you an even better support experience!

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

Comments

  •  11
    Issac started the conversation

    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

    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

    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

    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

    Hi issacchua,

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

  •  11
    Issac replied

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

  • [deleted] replied

    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

    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

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

  • [deleted] replied

    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

    Already did. Thank you for your support!