CRXI - Pull 7am to 7am for each day

[wld1957]

CRXI - It has been awhile since I had to write a formula. I have been trying to get the data to pull records for the following time frame. Since this is done on a daily basis I have tried to use Today -1 to Today but have not been able to include the time frame. I have tried several time variations but have not been sucessful. Any thought would be greatly appreciated.

{CAS_Action.ReceivedTime} = Today -1 to today (this pulls both days).

Daily - between 7:00AM previous day to 7:00AM Current Day

Bill

 

[wld1957]

After some testing I figured it out. I had to combine the the date and time fields and then use them in a formula that I put in the select criteria.

datetime(date({CAS_Action.ReceivedDate}),time({CAS_Action.ReceivedTime}))

{@DateTimeCombo} > DateTime(Year(CurrentDate),Month(CurrentDate),Day(CurrentDate),07,00,00)-1 and
{@DateTimeCombo} <= DateTime(Year(CurrentDate),Month(CurrentDate),Day(CurrentDate),7,00,00) and