How to use specific dates in between function? Or what other function I can use to display data from a specified interval?


I am usually using the between function in the following way, e.g. to display data between a month ago (counting from today) and today


but I need to show on a klip data from a certain time interval, e.g. between May 16th 2019 and June 15th 2019 and I do not want the dates to move.

Can I use specific dates in the between function like between(2019-05-16 and 2019-06-15)? If yes, can you give me an example how to do it?

I am just not sure in what format should the dates be provided and if I maybe need to use the DATE function as well?


Please sign in to leave a comment.