Query filter "current date - N hours" | Community
Skip to main content
salvdangelo
salvdangeloAccepted solution
Level 5
Dec 15, 2017 5:50 PM UTC

Is it
SubHours( GetDate() , N)

reliable?

View reply

4 replies

ramakatt
Employee
Dec 18, 2017 12:46 PM UTC

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

Adobe Campaign Help | List of functions

Translate
    ramakatt
    Employee
    Dec 18, 2017 7:11 AM UTC

    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

    Translate
      ShrawanSaxena-1
      ShrawanSaxena-1
      Employee
      Dec 16, 2017 7:54 AM UTC

      Hi Salvatore,

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

      Translate
        salvdangelo
        salvdangeloAuthorAccepted solution
        Level 5
        Dec 15, 2017 5:50 PM UTC

        Is it
        SubHours( GetDate() , N)

        reliable?

        Translate
        Terms & ConditionsAccessibility statement

        Loading footer...