0

Use one date to filter multiple fields

Hello,

We are trying to make it so that a user can select a single date and it will filter the data similar to this where clause, replacing the ? with the date:

where trans_date<=? and effective_date<=? and expiration_date>=?

I tried using a global parameter but then couldn't figure out how to get it to tie to the model values.  Any thoughts on how to do this?

2 replies

null
    • VP Product Management
    • Ian_Macdonald
    • 2 mths ago
    • Reported - view

    Hi 

    What are the relationships between the three dates? Are they all present on the individual rows of the underlying table? I.e. all part of the same record?

    Ian

      • Robert_Clark
      • yesterday
      • Reported - view

       the trans_date is in one table and the effective_date and expiration_date are in another field

Login to reply

Content aside

  • yesterdayLast active
  • 2Replies
  • 34Views
  • 2 Following