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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

need to calculate datetime range for previous day

Status
Not open for further replies.

kaliak

Programmer
Jan 16, 2006
7
US
crystal XI, windows XP

the following is part of select criteria:
{RSK_Occurrence.s_DateAssignedProvider} in DateTime (2008, 11, 20, 00, 00, 00) to DateTime (2008, 11, 20, 23, 59, 00)

I am looking for data from the previous day, so instead of
having to go into this report every day to change the date range, I want to create a formula to put into the select criteria, so report can be run from central management console.

Please let me know if I need to put more info in note.

thanks!

 
this thread title answered my question: datetime - last 24 hours, 26 oct 06
 
For future reference, there is a thread number at the beginning of each thread, and if you copy it like the one for the current thread: thread767-1515176 , it becomes a link so that others can navigate. There cannot be a space after the word thread.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top