Skip to Content
avatar image
Former Member

Date Value is null

Hello all

In a DSO there are two charecteristics date fields namely 'Posting Date' and 'Document Date'. Now I need to build one query based on 'user input date'. My requirement is as following

( User input date >= Posting date ) and ( User input date < Document date or Document Date is null )

Any suggestions.

Thanx.

Partha Bardhan

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jun 23, 2010 at 10:01 AM

    Hi,

    You may create a formula variable on User Input date and put the global filters on posting date and document date using that variable. You may provide option of >=, or > as per your need.

    I hope this will satisfy your requirement.

    S

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 23, 2010 at 10:12 AM

    create a formula on this

    ( User input date >= Posting date ) and ( User input date < Document date or Document Date is null )

    then put a condition on this

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      HI,

      If the posting date and the Document date are keyfigures then you can create a calculated KF with the required condition and then apply a query level condition on this calculated keyfigure like stated int eh above post.

      if the posting date and the document date is a cherecteristic, then we can put a global filter on these charecteristics in query level with replacement path variables that replces the User Input date.

      Hope this helps.

      Regards.

      Shafi.