if difference between two timestamps is smaller than

Quentinn — Sat, 15 Jan 2022 14:00:50 GMT

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

Re: if difference between two timestamps is smaller than

MarcoWedel — Sat, 15 Jan 2022 17:45:34 GMT

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

hope this helps

Marco