Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Calculation of date between a range

edited Apr 4, 2017 2:54PM in Reporting & Analytics for B2C Service 4 comments

Content

Hi,

We have converted SRs from our legacy system to the OSvC recently.

I need to create a report which can show how many incidents were created between a time frame, for example, a ticket created between Mar the 1st and March 31st.

This will have to take into account an nvl(incidents.c$ac_migration_createdon,incidents.created)

Can I do something like count(if('2017-03-01 00:00:00'<nvl(incidents.c$ac_migration_createdon,incidents.created)<'2017-03-30 23:59:59),1,0))?  I have tried this but something isn't working properly.

 

TIA

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!