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!
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))
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
