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