Solved

Help with Start Date in Report Designer

  • 15 March 2024
  • 4 replies
  • 38 views
T
Rank
Badge

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!!

 

 

icon

Best answer by hgilbert 15 March 2024, 17:25

View original
TamiLynn

4 replies

ejmillar
Rank
Userlevel 3
Badge

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.~
H
Rank
Userlevel 3
Badge

You could also use 

 

 

Helen
T
Rank
Badge

Thank you.

 

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

 

 

TamiLynn
T
Rank
Badge

This one worked! 

 

Thank you so much!!

TamiLynn

Reply


Terms & ConditionsCookie 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