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
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.
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
Try this:
AND(
([Date_Time] > (DATETIME(TODAY() + 1) + "017:00:00")),
([Date_Time] <= (DATETIME(TODAY()) + "017:00:00"))
)
that worked, that you all…super helpful.
Ah see, that’s what I get for rushing a response out without testing it first!!
User | Count |
---|---|
25 | |
24 | |
24 | |
20 | |
16 |