Skip to Content
avatar image
Sam Govaski

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

Feb 06, 2018 at 09:25 PM | 41 Views | Last edit Feb 06, 2018 at 09:40 PM 3 rev.

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!

SAP BusinessObjects - Web Intelligence (WebI)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Kuldeep Ghosh
    Feb 22, 2018 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