10 Replies Latest reply: Nov 14, 2016 3:53 PM by Fabio Mazzarelli RSS

    extract data from a range of date

    Fabio Mazzarelli

      Hi

      i use 2 variables.

      1)vFrom (eg. 11/11/2016)

      and

      2) vTo (example 13/11/2016).

      Example:

      From (11/November/2016)

      vTo (13/November/2016)

      OrderDate: I need to extract all data that fall between the range of date (11/november, 12/november, 13/novembre)

       

      My idea is to use a similar formula:

      only(If([OrderDate] >= vFrom and <= vTo, [OrderDate], 'error')

      but it doesn't work.

       

      Could you suggest a "method"?

       

      Thanks