Wednesday, September 25, 2013

Dates in PowerPivot

The "Truncate times if..." tip there helped me in analyzing the email log files I downloaded from SFDC.  The timestamps came in this format "7/2/2013 6:41:40 PM", so a TRUNC([EmailDate], 0) gives me an easy way to group things right after importing the log into PowerPivot.

No comments:

Post a Comment