Hello, I'm having a question, I think it may be basic because I'm starting to use Klipfolio, anyway the question is how can I put a date function so that the data of the day is counted automatically, without the need to put the date manually, now taking the data from my CRM from the due_date = '2019-06-01' for example, would have a function so that every day the data is renewed according to the data of the day?

1 comment

  • 0
    Rahul Bura

    Hey Ambra,

    Thanks for reaching out! Glad to hear from you! :) You can use our Date/Time functions to get Todays date. The TODAY() function returns today's date and you can use the DATEVALUE funtion to convert TODAY() to yyyy-MM-dd format to do a comparison to the date in your datasource.

    More info on each of these functions here: https://support.klipfolio.com/hc/en-us/articles/360011416893-Klipfolio-functions

    Now if you are looking to just filter data that has Today's date, you can also simply use our date filter to filter for Today:

Please sign in to leave a comment.