Skip to main content
Question

Report Date Parameter Can Set Min Max

  • Oct 17, 2023 5:46 AM UTC
  • 6 replies
  • 186 views
  • Translate All
Freshman I

Hi Everyone, Report Parameter Can Set Today Date Value as Max Date, Can Disable From Tomorrow date, please help me to solve this issue

 

 

    6 replies

    Laura03
    Captain II
    Forum|alt.badge.img+20
    • Laura03
    • Captain II
    • Oct 17, 2023 9:43 AM UTC

    Hello,

    I have an idea you can try: Please open above unknown report in Acumatica Report Designer. Click File, Schema Builder, and go to Parameters tab. Click on the Date Parameter and click [...] to see Expression Editor.

    Add Code like, Less than or equal @Today .   Save report as New Version.

     

    Save report as New Version

    Laura

    Translate
    ~ Laura Barber, WM Synergy
      Semi-Pro I
      Forum|alt.badge.img+8
      • ChandraM
      • Semi-Pro I
      • Oct 17, 2023 12:42 PM UTC

      Hi @sathish80 Is it possible to share the report to verify the output and suggest.

      Thanks

      Translate
      Chandra M
      StevenRatner
      Varsity I
      Forum|alt.badge.img

      Hi @sathish80, I agree with @Laura02 solution to at least getting the date to default to @Today for the report perimeters.

      Translate
      Steve - Klear Systems
        Freshman I
        • sathish80
        • Author
        • Freshman I
        • Oct 18, 2023 3:46 AM UTC

        I used Date Parameter following screenshots, but I can Select Future Date, @Laura02  is Anything I missout?

        Translate
        Freshman I
        • sathish80
        • Author
        • Freshman I
        • Oct 20, 2023 2:05 AM UTC

        Hello,

        I have an idea you can try: Please open above unknown report in Acumatica Report Designer. Click File, Schema Builder, and go to Parameters tab. Click on the Date Parameter and click [...] to see Expression Editor.

        Add Code like, Less than or equal @Today .   Save report as New Version.

         

        Save report as New Version

        Laura

        I can select Future Date any other solution?

         

        Translate
        Chris Hackett
        Community Manager
        Forum|alt.badge.img
        • Chris Hackett
        • Acumatica Community Manager
        • Nov 29, 2023 8:47 PM UTC

        Hi @sathish80 were you able to find a solution? Thank you!

        Translate
        Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
        Terms & ConditionsAccessibility statement
        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