Welcome to the RingCentral Community

Make sure to review our Terms of Use and Community Guidelines.

Please note the community is currently under maintenance and is read-only.

Home » Developers

Call Logs - Date only format for the date in the DATE column

Tags: call logs

Dec 26, 2018 at 7:06am • 1 replies • 0 likes

Avi

When the Call Log is downloaded as a CSV file (later saved as Excel), the DATE in the Date Column prefixes the day of the week (ie. Mon, Wed) to the date. Is there a way to format the DATE as Date Only or without the day of the week? Otherwise the date column will sort by the day of the week which doesn't work for my purpose.

1 Answer

Phong Vu answered on Dec 26, 2018 at 7:48am

Hi,

I believe that either your code changes the format or your Excel settings converts the date format. RingCentral system returns the date in ISO 8601 format including timezone, for example 2018-12-26T18:00:55.530Z.

You can do a quick check by opening the CSV file with a text editor to see if the date was converted. Otherwise, check your code or share a few lines of code where you create your CSV file and save the response so I can help.

+ Phong

A new Community is coming to RingCentral!

Posts are currently read-only as we transition into our new platform.

We thank you for your patience
during this downtime.

Try Workflow Builder

Did you know you can easily automate tasks like responding to SMS, team messages, and more? Plus it's included with RingCentral Video and RingEX plans!

Try RingCentral Workflow Builder

PRODUCTS
RingEX
Message
Video
Phone

OPEN ECOSYSTEM
Developer Platform
APIs
Integrated Apps
App Gallery
Developer support
Games and rewards

RESOURCES
Resource center
Blog
Product Releases
Accessibility

QUICK LINKS
App Download
RingCentral App login
Admin Portal Login
Contact Sales