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?
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