CHAPTER 7Using Column Formulaswith Date and Time Data

Copyright © 2009 by The McGraw-Hill Companies, Inc. Click here for terms of use.

In most cases, when you are analyzing your business data, you are interested in seeing a specific portion of the data rather than every record in your database. One element that is commonly of interest to all users of On Demand, regardless of industry, sale process, service methodologies, or size, is the element of time. Everyone has at least one report need that examines data based on time.

The most important thing to be aware of when working with date and time fields is that there are two distinct types of fields. The Date field type contains only a date. The Timestamp field type contains both a date and time. ...

Get Oracle CRM On Demand Reporting now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.