0

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

Hello,

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

(between(date(slice(@F:F;),"yyyy-MM-dd"),date_add(today(),"3","-1"),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?

0 comments

Please sign in to leave a comment.