Skip to Content

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

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!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

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
    10|10000 characters needed characters exceeded