Skip to main content
Solved

using a tester for a range of time?

  • Nov 19, 2026 3:40 PM UTC
  • 2 replies
  • 19 views

parke372
Supporter
Forum|alt.badge.img+11

similar to this question:
 


but a little different, in that i need a dynamic range.
i’m going to be using this form in an automated flow that triggers once per min. i want to see filter everything that falls within the last minute.
my input to the tester looks like:

UTC_Current_Time SrcName CreationTime EventId SrcState
15:17 HLD_HW_W_West_Ret 15:17 6211 Active
15:17 FTB_HVAC13_RaCo2 15:17 6205 Active
15:17 CCR_RmE20B_DPtoE20A_Lo 15:15 1029 Active
15:17 CCR_RmE20B_DPtoE20A 15:12 1028 Active
15:17 SHW01D900 15:12 6176 Active
15:17 NSB_CHW_CHLR1_Ret 15:09 11232 Active
15:17 FTB_HVAC13_RaCo2 15:16 6206 Active

 

what i want to do is have a tester for within a min of the current UTC time column.

so both FTB_HVAC13_RaCo2 would qualify, but CCR_RmE20B_DPtoE20A_Lo would not - because it’s 2 mins behind, not just one.
 

i thought it might be as simple as this:
 

but that doesn’t seem to work:
 

next i tried to leverage the @DateTimeDiff function in an attribute creator:
 

but i get a <null> output:
 

even though in an attribute manager it shows them as datetime format:
 

i’m not really sure what my other options might be?

Best answer by ebygomm

Two things

1) you need to specify the interval in your DateDiff expression

@Evaluate(@DateTimeDiff(@Value(UTC_Current_Time),@Value(CreationTime),Minutes))

2) DateDiff expects an ISO time so format the times as e.g. 15:31:00 

View original

2 replies

ebygomm
Evangelist
Forum|alt.badge.img+54
  • Evangelist
  • Best Answer
  • Nov 19, 2026 4:04 PM UTC

Two things

1) you need to specify the interval in your DateDiff expression

@Evaluate(@DateTimeDiff(@Value(UTC_Current_Time),@Value(CreationTime),Minutes))

2) DateDiff expects an ISO time so format the times as e.g. 15:31:00 


parke372
Supporter
Forum|alt.badge.img+11
  • Author
  • Supporter
  • Nov 19, 2026 4:14 PM UTC

thanks! the iso format made all the difference.