What's new in Customer Journeys?

Connect and learn more! ×
Insight (OBIEE) Tips | Removing the timestamp from a date — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Insight (OBIEE) Tips | Removing the timestamp from a date

Received Response
in Eloqua 9 comments

Have you wondered how to get rid of a timestamp in a date column? Here’s a method..

Here is a simple email report that shows the total sends on a given date.

Subject area: Email Analysis by Send Date

The problem is that i don’t want to see the total sends by day and time… I want to a total by day.

Let’s fix it!

Email Send Date vs Calendar Day attributes

First off, instead of Email Send Date, use the Email Send Calendar attribute called Day. Why? This attribute rolls up all emails sends by day. Whereas the Email Send Date is the date and time of the email send.


Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!