cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
573
Views
0
Helpful
1
Replies

Inbound-Outbound Call Reports

megaco123
Level 1
Level 1

Hi Guys/Gals,

In CRA Historical Reports you can pull stats on inbound calls direct from the CR_DB and the dates are in a standard date/time format.

On Call Manager CDR the date/time is in Jillian format.

Someone has asked me to produce a report that compares the stats, is their any SQL function that can convert normal date/time format (from report template) into jullian to run queries?

Im thinking on the lines of stored procedures.

1 Reply 1

ebreniz
Level 6
Level 6

I think once the csv format is pulled you may able to do this