Skip to main content
Level 3
Jun 12, 2025 3:34 PM UTC
Solved

Query node with a datetime format field

Hello everyone,

 

In a query node in a workflow, I have as target dimension broadLogRCP and I want to filter by those records that have in the event date the date of June 3, but the event date field is of type datetime, how would I define it?

 

Thanks

ParthaSarathy
ParthaSarathyAccepted solution
Community Advisor
Jun 12, 2025 3:47 PM UTC

Hi @lar1985 ,

Easiest way is, You can filter as:

event date on or after 03/06/2025 00:00:00 

AND

event date Before 04/06/2025 00:00:00 (in both conditions select the date value from calendar dropdown)

~  ParthaSarathy S

2 replies

ParthaSarathy
Community Advisor
ParthaSarathyCommunity AdvisorAccepted solution
Community Advisor
Jun 12, 2025 3:47 PM UTC

Hi @lar1985 ,

Easiest way is, You can filter as:

event date on or after 03/06/2025 00:00:00 

AND

event date Before 04/06/2025 00:00:00 (in both conditions select the date value from calendar dropdown)

Translate
~  ParthaSarathy S
Thanongdach
Level 3
Jun 13, 2025 2:54 AM UTC

@lar1985  

Field: eventDate
Operator: "between"
Value:

Start: 2025-06-03 00:00:00

End:  2025-06-03 23:59:59


Or
sql 
eventDate >= '2025-06-03 00:00:00' AND eventDate <= '2025-06-03 23:59:59'



Translate