Query node with a datetime format field

[LAR1985]

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 · Accepted solution]

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)

[Thanongdach]

@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'