Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Query filter "current date - N hours"

Avatar

Avatar
Validate 25
Level 4
salvdangelo
Level 4

Likes

45 likes

Total Posts

130 posts

Correct Reply

4 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Boost 5
Boost 3
View profile

Avatar
Validate 25
Level 4
salvdangelo
Level 4

Likes

45 likes

Total Posts

130 posts

Correct Reply

4 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Boost 5
Boost 3
View profile
salvdangelo
Level 4

15-12-2017

Hi,

how do I set this filter?

@eventDate   <on or after> "current date - N hours"

I don't know how to express "current date - N hours" in a Adobe Campaign syntax.
May anybody help me?

Salvatore


Jean-Serge Biron
@nkur
Adhiyan
kirti.rawat
Adobe Campaign

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 25
Level 4
salvdangelo
Level 4

Likes

45 likes

Total Posts

130 posts

Correct Reply

4 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Boost 5
Boost 3
View profile

Avatar
Validate 25
Level 4
salvdangelo
Level 4

Likes

45 likes

Total Posts

130 posts

Correct Reply

4 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Boost 5
Boost 3
View profile
salvdangelo
Level 4

15-12-2017

Is it
SubHours( GetDate() , N)

reliable?

Answers (3)

Answers (3)

Avatar

Avatar
Validate 1
Employee
RamaRajesh
Employee

Likes

40 likes

Total Posts

81 posts

Correct Reply

10 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Validate 1
Employee
RamaRajesh
Employee

Likes

40 likes

Total Posts

81 posts

Correct Reply

10 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile
RamaRajesh
Employee

18-12-2017

Other useful list of functions for everyone's reference, below.

Adobe Campaign Help | List of functions

Avatar

Avatar
Validate 1
Employee
RamaRajesh
Employee

Likes

40 likes

Total Posts

81 posts

Correct Reply

10 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Validate 1
Employee
RamaRajesh
Employee

Likes

40 likes

Total Posts

81 posts

Correct Reply

10 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile
RamaRajesh
Employee

17-12-2017

Example below:

Select the less than operator. In the Value column, click Edit expression. For date processing, go to the Formula type window, enter "1" in Current date minus n days.

Click Finish

query_editor_nveau_65.png

Avatar

Avatar
Boost 50
Employee
shrawans3153003
Employee

Likes

69 likes

Total Posts

150 posts

Correct Reply

66 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Boost 50
Employee
shrawans3153003
Employee

Likes

69 likes

Total Posts

150 posts

Correct Reply

66 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 10
View profile
shrawans3153003
Employee

15-12-2017

Hi Salvatore,

Yes , it can be used to get a "current date - N hours" value