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

SOLVED

Query filter "current date - N hours"

salvdangelo
Level 5
Level 5

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

1 Accepted Solution
salvdangelo
Correct answer by
Level 5
Level 5

Is it
SubHours( GetDate() , N)

reliable?

View solution in original post

4 Replies
salvdangelo
Correct answer by
Level 5
Level 5

Is it
SubHours( GetDate() , N)

reliable?

View solution in original post

shrawans3153003
Employee
Employee

Hi Salvatore,

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

RamaRajesh
Employee
Employee

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