Skip to main content
Solved

Date range for 2 different years 2025 and 2026 YTD

  • September 29, 2026
  • 4 replies
  • 20 views
Freshman II
Forum|alt.badge.img

Hi, so i have created this YTD GI report. I'm trying to insert in date ranges that can make me see both years at the same time. But when I finish no data is showing. Can I get help please

 

Best answer by BenjaminCrisman

​@SandyA I think you need brackets around your date conditions and then use an OR operator because no date will exist between both of those sets or ranges simultaneous, which is what AND requires

    4 replies

    BenjaminCrisman
    Acumatica Employee
    Forum|alt.badge.img+4
    • BenjaminCrisman
    • Acumatica Support Team
    • Answer
    • September 29, 2026

    ​@SandyA I think you need brackets around your date conditions and then use an OR operator because no date will exist between both of those sets or ranges simultaneous, which is what AND requires

      Freshman II
      Forum|alt.badge.img
      • SandyA
      • Author
      • Freshman II
      • September 29, 2026

      ​@BenjaminCrisman  thanks a lot. that part has been solved. I see data now. But the date range is only working for 2025

        Freshman II
        Forum|alt.badge.img
        • SandyA
        • Author
        • Freshman II
        • September 29, 2026

        ​@BenjaminCrisman Hey, I’ve figured out thanks a lot. I just had to change the formula in the Results Grid for 2026 YTD

          BenjaminCrisman
          Acumatica Employee
          Forum|alt.badge.img+4
          • BenjaminCrisman
          • Acumatica Support Team
          • September 29, 2026

          ​@SandyA Excellent! Glad it’s working now!

            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