Skip to Content
0

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

Feb 06 at 09:25 PM

40

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?

0
Former Member

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

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

1 Answer

Kuldeep Ghosh Feb 22 at 10:59 AM
0

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

Or

=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

Share
10 |10000 characters needed characters left characters exceeded