Skip to main content
Solved

Help with Start Date in Report Designer

  • March 15, 2024
  • 4 replies
  • 150 views
  • Translate All

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

4 replies

ejmillar
Semi-Pro II
Forum|alt.badge.img+1
  • Semi-Pro II
  • March 15, 2024

The following formula will give you yesterday’s date:

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

Translate

Forum|alt.badge.img+1
  • Varsity I
  • Answer
  • March 15, 2024

You could also use 

 

 

Translate

  • Author
  • March 15, 2024

Thank you.

 

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

 

 

Translate

  • Author
  • March 15, 2024

This one worked! 

 

Thank you so much!!

Translate