Community
Ecosystem
Forum
Events
MPUG
Support
KnowledgeBase
Support Portal
Customer Portal
Training
CONTACT US
Back to MinistryPlatform Site
Back 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
.
Knowledge Base
>
MinistryPlatform
>
Customization
>
Extending the Platform
>
SQL and Databases
>
SQL Functions
>
GETDATE
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
Contact Changes
Group Participants in Selection
Resources
Dynamic Dates
MSDN: GETDATE Function
DATEADD
DATEDIFF
DATEPART
DATENAME
When autocomplete results are available use up and down arrows to review and enter to select.
Knowledgebase
MinistryPlatform
Customization
Extending the Platform
SQL and Databases
SQL Functions
×
Share Feedback
Please help us improve the KB.
Was the KB article helpful?
Yes
No