if difference between two timestamps is smaller than

[Quentinn]

Hi everyone, can't figure out how to write this.

I want to write a syntax to determine if the difference between two timestamps is smaller than 4 days

The best I came up with is this, but it won't work

count (if (INTERVAL(DATE(FirstValidatingDateTime - RegistrationDateTime),'ss') < 345600, 'sampleid'))

The idea is to count the sampleid's for which the difference between firstval and registration is less than 4 days (345600 seconds)

Can anyone help?

Cheers

[MarcoWedel · Accepted solution]

Count({$<sampleid={"=FirstValidatingDateTime-RegistrationDateTime < 4"}>} sampleid)

hope this helps

Marco