Skip to Content

How to hard code report to return data between Yesterday 6PM till Today 6PM dynamically?

Feb 06 at 09:25 PM


avatar image
Former Member

Hello Experts,

I am looking for solution to hardcode my report to return the data entered between Current Date()-1 6PM and CurrentDate() 6PM? So results sets should return only data entered between above 24hrs only.

Yesterday 6PM till Today 6PM

Thank You!

10 |10000 characters needed characters left characters exceeded

can you please provide more details on where you want to restrict at query prompt level or at report level with filter condition?

Former Member

Thanks Amit I added that in Where clause in database it self.

* Please Login or Register to Answer, Follow or Comment.

1 Answer

Kuldeep Ghosh Feb 22 at 10:59 AM

Try this, see if this works:

=If(FormatDate([Calendar Date];"dd/MM/yyyy hh:mm") Between(FormatDate(RelativeDate([Calendar Date];-1);"dd/MM/yyyy 06:00");FormatDate([Calendar Date];"dd/MM/yyyy 06:00"))) Then 1 Else 0


=if(formatdate([Calendar Date];"dd/MM/yyyy hh:mm") >=FormatDate(RelativeDate([Calendar Date];-1);"dd/MM/yyyy 06:00") and formatdate([Calendar Date];"dd/MM/yyyy hh:mm") <= FormatDate(RelativeDate([Calendar Date]);"dd/MM/yyyy 06:00")) then 1 else 0

10 |10000 characters needed characters left characters exceeded