Yesterday's Data selection

[plextor]

I'm attempting to create a record selection formula that selects the previous day's data from 12:00am to 12:00pm. I tried to create something that only selects the date and ingores the time but, it doesn't work properly: Here's what i tried so far.

{amTicket.dtOpened} >=

cdatetime(year(currentdate-1),month(currentdate-1),day(currentdate-1),0,0,0) and
{amTicket.dtOpened} <= cdatetime(year(currentdate-1),month(currentdate-1),day(currentdate-1),23,59,59)

Thank you.
Brian

 

[bdreed35]

Try this:

{amTicket.dtOpened} =  CurrentDate - 1

Place it in your Record Selection Criteria.

~Brian

 

[plextor]

It's acting the same way.

Is their a way to also select a time range within the forumla. For example 12am to 12pm..

Thanks again.
Brian

 

[hilfy]

Try this:

{amTicket.dtOpened} > CurrentDate - 1 and
{amTicket.dtOpened} < CurrentDate

-D

 

[synapsevampire]

Try:

(
{amTicket.dtOpened} >= cdatetime(year(currentdate),month(currentdate),day(currentdate),0,0,0)
and
{amTicket.dtOpened} <= cdatetime(year(currentdate),month(currentdate),day(currentdate),12,0,0)
)

-k

 

[plextor]

Thank you very much... That did the trick