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

306

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

296

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

297

Replies

1
Sign in to like this content

Total Likes

Translate
Translate
Jump to reply
Related Conversations
How can the values ​​of a query be grouped by a variable Solved

Views

164

Likes

0

Replies

1
Big Query External Account - Data Loading Error in Non Admin User Solved

Views

490

Likes

0

Replies

9
Transform SQL code into Query Solved

Views

287

Likes

0

Replies

2
JS activity or Query Activity Solved

Views

404

Likes

0

Replies

4
Usage of aggregate functions- Rank and Ceiling while using enrichment and query activity in adobe campaign classic

Views

114

Likes

0

Replies

1