Query filter "current date - N hours"

Avatar

Avatar

salvdangelo

Avatar

salvdangelo

salvdangelo

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

salvdangelo

Avatar

salvdangelo

salvdangelo

15-12-2017

Is it
SubHours( GetDate() , N)

reliable?

Answers (3)

Answers (3)

Avatar

Avatar

RamaRajesh

Employee

Avatar

RamaRajesh

Employee

RamaRajesh
Employee

18-12-2017

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

Adobe Campaign Help | List of functions

Avatar

Avatar

RamaRajesh

Employee

Avatar

RamaRajesh

Employee

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

shrawans3153003

Employee

Avatar

shrawans3153003

Employee

shrawans3153003
Employee

15-12-2017

Hi Salvatore,

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