Is there a way to get the date a quote expired or ...
# general
j
Is there a way to get the date a quote expired or was processed? Do they share any date field for that? I want to be able to filter by date expired/processed
d
For expired, you'll want
Due Date/Receive By
For processed, you'll want
Date Closed
date closed will be blank for expired quotes, so you can use a simple
NVL
to put them in one column
LMK how you get on
j
Ended up using last modified, but thanks!
d
cool 👍 worth mentioning that last modified might be more recent then the expiry date/processed date