InsideSales.com
InsideSales.com
InsideSales.com Menu

Date and Time Functions


Function

Definition

Example

COUNT_DAYS Counts the number of whole days between the given start and end dates, excluding any identified dates
DATE Accepts a date string and returns the epoch for that date
DATE_ADD Adds the given unit amount to the date; use negative amounts to subtract
DATE_CLOSEST Finds the closest day of the week either before or after the given dates, including the given dates
DATE_CONVERT Converts the given values form one date format to another
DATE_ENDOF Retrieves the end date of the given unit relative to the given date
DATE_IN Determines if a date is in the given time period
DATERANGE Returns all dates between the specified start and end dates
DATE_SET Sets time units to specific values for each of the given dates
DATE_STARTOF Retrieves the start date of the given unit relative to the given date
DATE_UNITVALUE Retrieves the value of the given unit from the given dates
DATEVALUE Accepts a numeric date and returns the date using the specified format
NOW Returns the current numeric epoch date and time
TODAY Returns the current numeric epoch date
YESTERDAY Returns the numerical date for yesterday

Release Notes

Find our most recent release notes.

Forum

Our InsideSales.com community forum is coming soon.

Advanced Training Guides

Advanced training for the PowerDialer for Salesforce.

Have questions?

We're happy to help. An InsideSales.com expert is just a phone call away.

(866) 593-2807

Mon-Fri 6-7 MST

Back To Top

© 2004–2014 InsideSales.com, Inc. all rights reserved. Use of the InsideSales.com service and this Web site constitutes acceptance of our Terms of Use and Privacy Policy. InsideSales.com technology is protected by the following United States Patents: 8078605, 8325738, 8352389, 8510382, 8566419.