Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
formula for yesterday 1
- Thread starter JSeidel
- Start date
synapsevampire
Programmer
In the Report->Edit Selection Formula->Record place something like:
{MyTable.MyDateField} = currentdate-1
Replacing MyTable.MyDateField with the date field from your table.
-k
{MyTable.MyDateField} = currentdate-1
Replacing MyTable.MyDateField with the date field from your table.
-k
-
1
- #3
If you mean you want to show records for the last business day, so if you run the report on Monday you get Friday's data, then in Report->Edit Selection Formula->Record:
If DayOfWeek(CurrentDate) = 2
Then {MyTable.MyDateField} = CurrentDate-3
Else CurrentDate-1
Naith
If DayOfWeek(CurrentDate) = 2
Then {MyTable.MyDateField} = CurrentDate-3
Else CurrentDate-1
Naith
- Status
Similar threads
- Locked
- Question
- Locked
- Question