Skip to main content
Question

Dynamic Date Field Only lets me choose '23 & '24

  • Jan 31, 2022 10:40 PM UTC
  • 0 replies
  • 63 views

I've made an Expiration date field a dynamic search, but the only years it lets me choose from is 2023 and 2024. Yes, there are dates in the field back to 2008

------------------------------
Greg Rosenbloom
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
The range of dates offered will only be those on the report.  So likely, these are no older dates on that particular report.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

For those of you with the same issue, I figured out my own problem.  We had some blank spots for the expiration which were filled in with the year 1900 and 1970 and had no other expiration year until 2008. This created a problem. We changed all the 1900 dates to 2000 and my issue was fixed.

------------------------------
Greg Rosenbloom
------------------------------