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?