Skip to main content
Solved

Filter Report by Date Parameter

S
Jr Varsity III
Forum|alt.badge.img

I have created a Date Parameter for a custom report.  I am trying to filter the report by this parameter, the result is coming back with no data (a blank report).  I am selecting a date that i am 100% sure is in the dataset because i have a raw dump of the data.  What am I missing, why is my filter not working?  Does this have something to do with the values being seen as text instead of date?

 

Best answer by ThasinduRanasinghe61

@sspencer in the filter section the final line you have used @Date_parameter equal ‘blank’. May be try after deleting that line or add the required value there.

View original
    Did this topic help you find an answer to your question?

    2 replies

    S
    Freshman I
    Forum|alt.badge.img
    • Shurtugal98
    • Freshman I
    • 13 replies
    • August 22, 2023

    @sspencer I had the same problem in a GI. It could be possible, that you cant EQUAL a date because it stores the time as well if i am not mistaken. Try to build a second parameter and work with GREATER THAN and the other parameter with LESS THAN. Or try it with GREATER THAN OR EQUAL with the current paramter.

    Chris Hackett
    1 person likes this
    • Chris Hackett
      Chris Hackett
    ThasinduRanasinghe61
    Jr Varsity I
    Forum|alt.badge.img

    @sspencer in the filter section the final line you have used @Date_parameter equal ‘blank’. May be try after deleting that line or add the required value there.

    Chris Hackett
    1 person likes this
    • Chris Hackett
      Chris Hackett

    Reply


    Most helpful members this week

    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings
    About Acumatica ERP system
    Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
    © 2008 — 2024  Acumatica, Inc. All rights reserved