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?
Date
Votes
1 comment
-
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.