Forum Discussion

GregRosenbloom's avatar
GregRosenbloom
Qrew Member
3 years ago

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

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
------------------------------
reports and charts
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 years ago
    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
    ------------------------------
  • GregRosenbloom's avatar
    GregRosenbloom
    Qrew Member
    3 years ago
    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
    ------------------------------