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!
-
can you please provide more details on where you want to restrict at query prompt level or at report level with filter condition?
-
Thanks Amit I added that in Where clause in database it self.
1 Answer
-
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
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
Add comment
Add comment