The CDR report in the CSV format now contains all of the CDR fields. Please note that the ‘calldate’ field contains the call time in the time zone that is configured for the current PBX user (ADMIN|Admin|Users| SETTINGS.) The ‘calldate_utc’ field contains the call time in the UTC time zone (exactly as it is kept in the database).
For example, the America/New_York (GMT -4:00) timezone is configured for user ‘admin’. There was a call made on 2017-Jun-26 at 9:00 am according to the New_York clock. The user ‘admin’ is logged in the Web interface. Then the following tales place:
– the call time stamp in the database CDR table is saved according to the UTC clock: 2017-Jun-26 13:00:00
– the ‘calldate’ field in the CSV file will contain the time stamp according to the New York clock: 2017-Jun-26 09:00:00
– the ‘calldate_utc’ field in the CSV file will contain the time stamp according to the UTC clock: 2017-Jun-26 13:00:00