Skip to main content
Level 3
June 12, 2025
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
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

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)

Translate
~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
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'



Translate