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 – Amelia, wpDataTables, 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 #1674168
filtering by today's date
Closed

Comments

  • ROB started the conversation

    I would like to know if it's possible to filter rows by the current (today's) date. I want to purchase but need to know before I buy. The only answer I found is to use SQL, but I find it hard to believe that a plugin with so many features can't filter and display entries by today's date using csv or excel format. Thanks in advance for your answer!

  • [deleted] replied

    Hi ROB,
    Thank you for the inquiry.

    Unfortunately there is no specific feature for filtering table by today's date but there is a workaround. In conditional formatting you can set the class to the rows that are not today's date by using placeholder %TODAY%. After that in custom CSS you just set display: none to the rows with that class and they will not be shown in the table. Another way is using MySQL as you mentioned.

    You can try our sandbox site: Front-end & Back-end - you can find a fully functional version there to try out all plugin features.

  • ROB replied

    Hi Milos!

    I really want to make this work and purchase your product, but I must admit that I understand nothing about coding and custom css and classes. I went to my date column and set conditional formatting to "set row css class" to %TODAY%. I left the line after "if cell value" empty, since a calendar pops up. Is this correct so far?

    Then I went to DISPLAY and CSS classes and entered display: none, but I'm sure I'm missing something since I know nothing about setting classes. Is there any chance you could help with a little more detail? Maybe a screenshot if possible of exactly what to enter? I really want to buy your product since it does everything else I need!

    Thank you Milos!

  • [deleted] replied

    Hi ROB,

    If you have purchased the plugin, please open a ticket in wpDataTables category with your purchase key and one of our developers will provide you help with that.

  • ROB replied

    I have not purchased yet, I wanted to test it before I bought it. Do I need to purchase first to get this answered? Thanks...

  • [deleted] replied

    Hi ROB,

    No, sorry for misunderstanding. I thought that you brought the plugin so I redirect you to customer support to help you with the issue.

     You should set like on the image from the attachment and then in CSS add this CSS rule:

    .something {
        display: none;
    }

  • ROB replied

    Thank you Milos! But when I try to set to %TODAY% it keeps reverting back to today's actual date, and it doesn't work (see attachment). I put the below code in my style.css file in my theme's child theme. 

    .something {
        display: none;
    } 
  • ROB replied

    Milos... I figured out where to put the custom css, your workaround works! Do you get any credit for a purchase or are you the owner? :) 

  •   [deleted] replied privately