Expression with set analysis

[#1]

Hi,

how do I write this expression with set analysis?

count(if(right([OP - start],5)>'07:14' and right([OP - start],5)<='08:35' and (Group='COP') and Ydate=year(today()) and (Mdate=month(today())-1),1))

Best regards
Krister

[Miguel_Angel_Baeyens · Accepted solution]

Hello Krister and welcome to the forums,

Although you may be interested in using timestamp() or date() functions to extract time and date from your timestamp fields, your request should be something like

Count({< [OP - start] = {"=Right([OP - start], 5) > '07:14'", "=Right([OP - start], 5) <= '08:35'"}, Group = {'COP'}, Ydate = {'$(=Year(Today()))'}, Mdate = {'$(=Month(Today()) -1)'} >} 1)

This is untested, so please check that parentheses and brackets are properly closed.

Regards.

[#3]

Thanks for your qick respons, I got it to work using your expression.

Best regards
Krister