Skip to main content
Answer

Help with Start Date in Report Designer

  • March 15, 2024
  • 4 replies
  • 101 views
T
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 

 

 

TamiLynn

    4 replies

    ejmillar
    Varsity II
    Forum|alt.badge.img+1
    • ejmillar
    • Varsity II
    • March 15, 2024

    The following formula will give you yesterday’s date:

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

    Ewan ~ Rubech IT ~ Please remember to "Mark Best Answer" to help those who are facing the same problem.~
    Chris Hackett
    H
    H
    Varsity I
    Forum|alt.badge.img+1
    • hgilbert
    • Varsity I
    • Answer
    • March 15, 2024

    You could also use 

     

     

    Helen
    Chris Hackett
    ejmillar
    T
    Jr Varsity III
    • thoyt76
    • Author
    • March 15, 2024

    Thank you.

     

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

     

     

    TamiLynn
    T
    Jr Varsity III
    • thoyt76
    • Author
    • March 15, 2024

    This one worked! 

     

    Thank you so much!!

    TamiLynn
    Chris Hackett
    H
    Terms & ConditionsCookie settingsAccessibility 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