Expand my Community achievements bar.

Adobe Campaign User Groups are live now. Join our Adobe Campaign User Groups and connect with your local leaders!
Join Now
SOLVED

EXPRESSION QUERY

Avatar

Level 3
Level 3
10/5/23 1:40:32 AM

Hi, can someone explain how to build the following data required?:

"users who were created one day ago"

 

bcollado_0-1696495173423.png

 

Can't find the way

 

Thank you very much!!

Views

329

Replies

2
Sign in to like this content

Total Likes

Translate
Translate
1 Accepted Solution

Avatar

Correct answer by
Community Advisor
Community Advisor
10/5/23 1:44:33 AM

Hi @bcollado ,

Query,

DateOnly(@created) EQUAL TO DateOnly(DaysAgo(1))

ParthaSarathy_0-1696495451955.png

 
~  ParthaSarathy S

View solution in original post

Views

319

Replies

1
Sign in to like this content

Total Likes

Translate
Translate
Jump to reply
2 Replies

Avatar

Correct answer by
Community Advisor
Community Advisor
10/5/23 1:44:33 AM

Hi @bcollado ,

Query,

DateOnly(@created) EQUAL TO DateOnly(DaysAgo(1))

ParthaSarathy_0-1696495451955.png

 
~  ParthaSarathy S

Views

320

Replies

1
Sign in to like this content

Total Likes

Translate
Translate
Jump to reply
Related Conversations
Query recipients while it is still loading? Solved

Views

84

Likes

0

Replies

1
Query on external File target mapping Solved

Views

106

Likes

0

Replies

1
Easily copying logic from query or filter to a split? Solved

Views

159

Likes

0

Replies

2
How to call instance variable instance.vars.xxx in one workflow in to another workflow sub query activity? Solved

Views

193

Likes

0

Replies

1
Using the Weekday function in a query Solved

Views

218

Likes

0

Replies

5