Query node with a datetime format field | Community
Skip to main content
L
LAR1985
Level 3
June 12, 2025
Solved

Query node with a datetime format field

  • June 12, 2025
  • 2 replies
  • 410 views

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

Best answer by ParthaSarathy

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)

2 replies

ParthaSarathy
Community Advisor
ParthaSarathyCommunity AdvisorAccepted solution
Community Advisor
June 12, 2025

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~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
Thanongdach
Thanongdach
Level 3
June 13, 2025

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



Terms & ConditionsAccessibility statement

Loading footer...