Skip to Content
avatar image
Former Member

comparing dates in query

Hi,

Im am using a query on AR.

I would like to exclude lines for which posting date of the FI document is equal to the clearing date of the FI document. The two caracteristics are available, but I dont know how to use them ?

thanks

J

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 17, 2007 at 01:22 PM

    Hello Ja,

    I reccomend you to find a certain characteristics value when those two is same. And then try to filter it in query definition. For example, when those two is same document type might be 'XXX' or another field might be a certain value.

    Sarhan.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 17, 2007 at 01:25 PM

    Create formula variable with processing type Replacement path for each date and you can use those variable to make a comparison in your report using formula. When creating the variable use Key and also the type should be date.

    Let me know if you still need anything on this.

    thanks.

    Wond

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hey when your substract one from the other if they are equal, then the result will be zero. you can use a condition on that not to display.

      thanks.

      Wond