how to filter for date time range

[JSeidel]

I need to be able to filter for "yesterday between 3pm and midnight" plus "today midnight till 6am" how do I write formulas to accomplish this?

 

[synapsevampire]

Try a record selection formula (Report->Edit Selection Formula->Record) containing:

(
{table.datetime} >= cdatetime(year(currentdate-1),month(currentdate-1),day(currentdate-1),15,0,0)
and
{table.datetime} <= cdatetime(year(currentdate-1),month(currentdate-1),day(currentdate-1),23,59,59)
)
and
(
{table.datetime} >= cdatetime(year(currentdate),month(currentdate),day(currentdate),0,0,0)
and
{table.datetime} <= cdatetime(year(currentdate),month(currentdate),day(currentdate),6,0,0)
)

-k

 

[Reebo99]

Slight change to the formula :
(
{table.datetime} >= cdatetime(year(currentdate-1),month(currentdate-1),day(currentdate-1),15,0,0)
and
{table.datetime} <= cdatetime(year(currentdate-1),month(currentdate-1),day(currentdate-1),23,59,59)
)
OR
(
{table.datetime} >= cdatetime(year(currentdate),month(currentdate),day(currentdate),0,0,0)
and
{table.datetime} <= cdatetime(year(currentdate),month(currentdate),day(currentdate),6,0,0)
)


Reebo
Scotland (Sunny with a Smile)