Skip to Content
0
Former Member
Apr 20, 2009 at 10:40 AM

Calculating the number for days

15 Views

Hi frnds,

I have a requirement like where Daily some hundreds of service tickets will be generated in CRM sysytem. we are loading data daily in to BI system. In My report I need to display the number of service tickets generated till yester day and also the number of service tickets generated today.

I have to use a variable for From and To date in between these From and To dates How many service tickets are generated and I have to calculate the number of tickets created till one day before the To date value and the number of tickets created on To date value

Here My question is how can I calculate the number tickets created on those two days?