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?

1 reply

null
    • VP Product Management
    • Ian_Macdonald
    • 2 wk 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

Login to reply

Content aside

  • 2 wk agoLast active
  • 1Replies
  • 14Views
  • 2 Following