# BAQ/Dashboard Dynamic date

**Category:** [Epicor ERP 9](https://www.epiusers.help/c/e9/7)
**Created:** 2016-11-28 19:36 UTC
**Views:** 736
**Replies:** 1
**URL:** https://www.epiusers.help/t/baq-dashboard-dynamic-date/36436

---

## Post #1 by @cchang

Is it possible in a BAQ or Dashboard to set a date based on a date selected?  For example, we have a Due Date that the user manually selects and then based on the Due Date selected, the Discount Date is <= +7 days.  I wasn't able to set this up as a Criteria in the 'specified parameter' in the BAQ or as a Tracker field in the Dashboard.

---

## Post #2 by @gpayne

I had a clever consultant do something like this. He added a button to the tracker view and used that to write a quantity value and the users id into a UD table.

The UD was joined to the query using the Company and the criteria was Constants.CurrentUserID = key1, key2-5 = ‘’ and the quantity was available for the baq.

---


**Canonical:** https://www.epiusers.help/t/baq-dashboard-dynamic-date/36436
**Original content:** https://www.epiusers.help/t/baq-dashboard-dynamic-date/36436