DateTimeDiff > x always the same result

[df]

Hi,

i have a problem with this formular:

when the difference between current timestamp and next timestamp  is bigger then 15 minutes it should be flaged with "1"

where is my mistake?

[LordNeilLord · Accepted solution]

Hey @df

Swap the order of your fields :)

 

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

[MarqueeCrew · Accepted solution]

I was going another direction:

IF DateTimeDiff([Row+1:Timestamp],[Timestamp],"Minutes") > 15
THEN 1
ELSE 0
ENDIF

swap the variables.

Cheers,

Mark

[jamielaird]

I was about to reply with yet another option - swap the > for <

IF DateTimeDiff([Timestamp DateTime],[Row+1:Timestamp DateTime],"minutes") < 15
THEN 1
ELSE 0
ENDIF

[LordNeilLord]

I actual change my mind...but still got it correct!

Oh well, you have answers for any way you want to do it :)

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

[df]

i thought DateTimeDiff(A,B) = DateTimeDiff(B,A) and is always a positive number o: