Slice Filter between 5p yesterday and 5p today

[dwiant]

I have a date_time field for when the record was created and want to create a filter slice that shows records between 5p yesterday and 5p today…how can I do that? I have tried a bunch of things but I just cannot get the right result.

Daniel

[WillowMobileSys]

You basically need to reconstruct the text representation of a DateTime at 5pm. So an expression in the Slice like this should work:

AND( [Date_Time] > CONCATENATE(TODAY() - 1, " 5:00 pm"), 
     [Date_Time] <= CONCATENATE(TODAY(), " 5:00 pm")
)

NOTE:  This is not tested.

[dwiant]

Arithmetic expression ‘([Install Date] > CONCATENATE((TODAY()-1),“12/30/1899 5:00:00 PM”))’ does not have valid input types

this is the error I get…seems like I get this on a lot of the ideas I’ve tried.

Grateful for the help - Daniel

[Steve]

Try this:

AND(
  ([Date_Time] > (DATETIME(TODAY() + 1) + "017:00:00")),
  ([Date_Time] <= (DATETIME(TODAY()) + "017:00:00"))
)

[dwiant]

that worked, that you all…super helpful.

[WillowMobileSys]

dwiant:

Arithmetic expression ‘([Install Date] > CONCATENATE((TODAY()-1),“12/30/1899 5:00:00 PM”))’ does not have valid input types

Ah see, that’s what I get for rushing a response out without testing it first!!