Skip to main content
Solved

Help with Start Date in Report Designer

  • Mar 15, 2024 3:11 PM UTC
  • 4 replies
  • 151 views
  • Translate All
Jr Varsity III

Hello,

My report returns no data when I use yesterday at the start date and end date. I runt this report daily for my boss to see all the orders created yesterday. To get the orders created yesterday, I use yesterday’s start date and today’s end date.

 

Can someone assist me with how to modify the below start date to default to yesterday? 

 

Thank you!!

 

 

Best answer by hgilbert

You could also use 

 

 

View original
TamiLynn

    4 replies

    ejmillar
    Semi-Pro II
    Forum|alt.badge.img+1
    • ejmillar
    • Semi-Pro II
    • Mar 15, 2024 4:22 PM UTC

    The following formula will give you yesterday’s date:

    =DateAdd( Today(), 'dd', -1)

    Translate
    Ewan ~ Rubech IT ~ Please remember to "Mark Best Answer" to help those who are facing the same problem.~
      Varsity I
      Forum|alt.badge.img+1
      • hgilbert
      • Varsity I
      • Answer
      • Mar 15, 2024 4:25 PM UTC

      You could also use 

       

       

      Translate
      Helen
        Jr Varsity III
        • thoyt76
        • Author
        • Mar 15, 2024 4:26 PM UTC

        Thank you.

         

        When I put that formula in “Default Value” I get the below error message:

         

         

        Translate
        TamiLynn
        Jr Varsity III
        • thoyt76
        • Author
        • Mar 15, 2024 4:37 PM UTC

        This one worked! 

         

        Thank you so much!!

        Translate
        TamiLynn
          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