Skip to main content
Solved

How to remove weekends from daily reports

  • Feb 16, 2026 4:48 PM UTC
  • 1 reply
  • 70 views
  • Translate All
Freshman I

Hello!

I currently have a report to show all orders entered for the prior date, and this is how it currently looks.

This works fine but on Monday’s this will try and pull orders on Sunday (our company is closed on Saturday and Sunday). What would I need to add in this section to have this report skip the weekend and show me Friday orders on Monday?

 

Thank you!

Best answer by dgranger70

If you uncheck the From Schema checkbox, you can click the pencil in Value 1 and use an IIF() statement and the DayOfWeek(), DateAdd(), and Today() functions to conditionally get the date value. 

 

=IIF(DayOfWeek(Today())=2, DateAdd(Today(), 'd', -3), DateAdd(Today(), 'd', -1))

View original

1 reply

Varsity II
Forum|alt.badge.img
  • dgranger70
  • Varsity II
  • Answer
  • Feb 16, 2026 5:31 PM UTC

If you uncheck the From Schema checkbox, you can click the pencil in Value 1 and use an IIF() statement and the DayOfWeek(), DateAdd(), and Today() functions to conditionally get the date value. 

 

=IIF(DayOfWeek(Today())=2, DateAdd(Today(), 'd', -3), DateAdd(Today(), 'd', -1))

Translate
    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