0

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

Hello,

how can I use the BETWEEN function to display some data between two specific dates (I do not what the dates to change), e.g. between May 16th 2019 and June 15th 2019?

I am used to using the function like this:

BETWEEN(DATE(@F:F;,"yyyy-MM-dd"),DATE_STARTOF(TODAY(),"3",-5)

but on one klip I need to display data from a specified time interval and I do not want this interval to move.

 

1 comment

  • 0
    Avatar
    Janice Janczyn

    Hi Dominika,

    You can hard-code the dates and convert them to Unix format using the DATE function, for example,

         BETWEEN( DATE(@F:F;,"yyyy-MM-dd"), DATE( 2019-05-16, "yyyy-MM-dd"), DATE( 2019-06-15, "yyyy-MM-dd") )

    Thanks,
             Janice

     

Please sign in to leave a comment.