CONTACT USBack to MinistryPlatform Site
Your Knowledge Base is moving on 3/25/24! Our new Help Center provides all the articles you know and love (plus so much more) in a one-stop shop. Ask your SPoC for details!

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