Query filter "current date - N hours"

[salvdangelo]

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​

[salvdangelo · Accepted solution]

Is it
SubHours( GetDate() , N)

reliable?

[shrawans3153003]

Hi Salvatore,

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

[RamaRajesh]

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

[RamaRajesh]

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

Adobe Campaign Help | List of functions