count if

[samuel_brierley]

count ({$< [Fault Cleared] = {"<=$=(Max([Date Detected]))"}>}[Fault Cleared]

Can someone explain what is wrong with this expression?

what its supposed to do is count all row where Fault Clearerd is less than the Max Date detected

[swuehl]

Field Fault Cleared is not recognized as a timestamp by QV, because it does not match the default timestamp format:

SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';

It's format is indeed

'DD/MM/YY hh:mm:ss'

like

25/01/13 20:07:02

It's best to handle that in the load script, either by correting your default timestamp format, or by interpreting the value on load:

LOAD

     ....

	timestamp#([Fault Cleared],'DD/MM/YY hh:mm:ss') as [Fault Cleared], ...

[samuel_brierley]

I LOVE YOU!!!!!!

[antose]

Help one of my customer with similar problems last week

Count({$< MatDatum={"<$(=Date(Today(), 'YYYYMMDD'))"} >} NyckelHuvudMITPLO)

So in you case can this works?

Count({$< [Fault Cleared] = {"<=$(=Date(Max([Date Detected]), 'DD/MM/YYYY'))"} >} [Fault Cleared])