Expand my Community achievements bar.

SOLVED

Query filter "current date - N hours"

Avatar

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

Avatar

Correct answer by
Level 5

Is it
SubHours( GetDate() , N)

reliable?

View solution in original post

4 Replies

Avatar

Correct answer by
Level 5

Is it
SubHours( GetDate() , N)

reliable?

Avatar

Employee

Hi Salvatore,

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

Avatar

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