0

I am trying to generate a report which should retrieve tickets that are resolved a working day before the current date. If I run the report on 14-OCt-2019 (Monday), then the results should fetch tickets resolved on 11-Oct-2019 (Friday)

I tried this query but it is not generating the expected results ( 'Last Resolved Date' >= ( $TIMESTAMP$ - 2 * 24 * 24 * 60) )

TylerH
  • 20,799
  • 66
  • 75
  • 101
Dan
  • 15
  • 1
  • 4

2 Answers2

1

Last Resolved Date sounds like a date field. You are using $TIMESTAMP$. Maybe you could consider using $DATE$ instead?

Besides that, I don't quite get the maths:

One day would be hours * minutes * seconds (24 * 60 * 60) (I don't recall if $TIMESTAMP$ uses milliseconds), nevertheless, this would give you the tickets in the last 24 hours, so If you check at 12:00 noon, you would only get part of the tickets.

I would use 'Last Resolved Date' >= ($DATE$ - ((60*60)*24))

JoSSte
  • 2,953
  • 6
  • 34
  • 54
0

if you have field for day of the week, add filter condition as your day of the week and try it.

nevergiveup
  • 63
  • 7