CONTACT USBack to MinistryPlatform Site
Your Knowledge Base has moved to the new Help Center.  Check out the release notes for details. And don't forget to update your bookmarks and in-house documentation before May 28.

GETDATE

 
Best Practice: Use The Domain Time Token (dp_DomainTime) rather than GETDATE() for best results.

GETDATE returns the current date and time.

Syntax

GETDATE()

Details

GETDATE can be modified by adding or subtracting whole days. For example, this is the date/time exactly 7 days ago:
 
GETDATE() - 7

View Examples

Resources