Query filter "current date - N hours" | Community
Skip to main content
Best answer by salvdangelo

Is it
SubHours( GetDate() , N)

reliable?

4 replies

salvdangelo
salvdangeloAuthorAccepted solution
Level 5
December 15, 2017

Is it
SubHours( GetDate() , N)

reliable?

ShrawanSaxena-1
Adobe Employee
ShrawanSaxena-1Adobe Employee
Adobe Employee
December 16, 2017

Hi Salvatore,

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

    R
    Adobe Employee
    ramakattAdobe Employee
    Adobe Employee
    December 18, 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

      R
      Adobe Employee
      ramakattAdobe Employee
      Adobe Employee
      December 18, 2017

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

      Adobe Campaign Help | List of functions

        Terms & ConditionsAccessibility statement

        Loading footer...