time

[master_student]

Hello community,

I need you for two things :

first, I would like to count person_ID if time (DATE_DEB) = '00:00:00' / I did like this but it didn' work : count (if (time (DATE_DEB)) ='00:00:00'))

the DATE_DEB field is like DD/MM/YYYY hh:mm:ss

second, I want to highlight in red the all record (in the table) when time (DATE_DEB) = '00:00:00'

Thank you very much

[fvelascog72]

Hi,

Take a look to the attached file.

Saludos.

[maxgro · Accepted solution]

you can check the time part of your field with frac function

frac(DATE_DEB)=0

[master_student]

Thank you all and for the second question to get the record in red please.

Thanks

[master_student]

Thank you Federico and how to get the record in red please.

[fvelascog72]

In the file you can see how to do it.

You can set background color in dimension properties.

Saludos.