Time range help please

[diceysoft]

i hope someone can help me with this.
i need to filter a report with the following time range: 16:00(the day before) - 15:59(the day the report is run)

ive tryed this formula :"{Command.RequestCreatedAt} >= Today-1" but i need to make the report time specific

thanks :)

[BrianL]

Hi Diceysoft,

There may be a more elegant way to do this but I believe a select expert of:

((Date({Command.RequestCreatedAt}) = Date(CurrentDate)-1 and
Time({Command.RequestCreatedAt}) >= Time(16:00:00)) or
(Date({Command.RequestCreatedAt}) = Date(CurrentDate) and
Time({Command.RequestCreatedAt}) < Time(16:00:00)))

Should get the results you're looking for.

Hope this helps,
Brian