Looking for PowerObjects? Don’t worry, you’re in the right place! We’ve been part of HCL for several years, and we’ve now taken the final step in our acquisition journey: moving our website to the HCL domain. Nothing else is changing – we are still fanatically focused on Microsoft Business Applications!

HCLTech Microsoft Business Applications Practice Blog

for Dynamics 365, Power Platform and the rest of the Microsoft technology stack

Reporting to the Second in Dynamics CRM

Post Author: HCLTech |

Hopefully you have a reporting genius at your company who will create custom Dynamics CRM reports for you on-the-fly. But if that's not the case—or that person is just out of the office today—you may be trying to gather CRM data on your own.

The reports area can give you a lot of information about your CRM data, but one thing it doesn't do automatically is show you the seconds! We have talked about the Date/Time field in the past, today's tidbit of information is centered around a clock's secondhand.

Let's say you need to know the exact second a record was created—maybe a touch point with your customer. If you create and run a CRM report and include Created On date, your results for that field will be formatted as mm/dd/yyyy hh:mm AM/PM.

To  view, export and analyze what second the record was created, follow these steps:

1. Select the Created On column in your report and select Change Properties.

Reporting to the Second in Dynamics CRM

2. Flag Include unformatted value column.

Reporting to the Second in Dynamics CRM

3. Now when you run the report, you will see both columns for Created On.

Reporting to the Second in Dynamics CRM

Note: You can also include the unformatted value column for field types Currency, Whole Number and Decimal.

If this was helpful to you, you can also check out our blogs on the Dynamics CRM User Summary Report and Reporting Options.

Happy CRM'ing!

By Joe D365
Joe D365 is a Microsoft Dynamics 365 superhero who runs on pure Dynamics adrenaline. As the face of PowerObjects, Joe D365’s mission is to reveal innovative ways to use Dynamics 365 and bring the application to more businesses and organizations around the world.

PowerObjects Recommends