Programmatic Marketing Content
jIntroduction to Programmatic Marketing Content
API: Add Object Array Item
API: Create Object
API: Invoke Create
API: Invoke Delete
API: Invoke Execute
API: Invoke Perform
API: Invoke Retrieve
API: Invoke Update
API: Raise Error
API: Set Object Property
Contacts: Upsert Contact
Content: Attach File
Content: Barcode URL
Content: Begin Impression Region
Content: Build Option List
Content: Build Row Set From String
Content: Build Row Set From XML
Content: Content Area
Content: Content Area by Name
Content: Content Block by ID
Content: Content Block by Key
Content: Content Block by Name
Content: Content Image by ID
Content: Content Image by Key
Content: Create SMS Conversation
Content: End Impression Region
Content: End SMS Conversation
Content: Get Portfolio Item
Content: Image
Content: Set SMS Conversation Next Keyword
Content: Transform XML
Content: Treat as Content
Content: Treat as Content Area
Content: Wat
Data Extension: Claim Row
Data Extension: Claim Row Value
Data Extension: Data Extension Row Count
Data Extension: Delete Data
Data Extension: Delete DE
Data Extension: Execute Filter
Data Extension: Execute Filter Ordered Rows
Data Extension: Field
Data Extension: Insert Data
Data Extension: Insert DE
Data Extension: Lookup
Data Extension: Lookup Ordered Rows
Data Extension: Lookup Ordered Rows CS
Data Extension: Lookup Rows
Data Extension: Lookup Rows CS
Data Extension: Row
Data Extension: Row Count
Data Extension: Update Data
Data Extension: Update DE
Data Extension: Upsert Data
Data Extension: Upsert DE
Date Time: Date Add
Date Time: Date Diff
Date Time: Date Parse
Date Time: Date Part
Date Time: Format Date
Date Time: Get Send Time
Date Time: Local Date to System Date
Date Time: Now
Date Time: System Date to Local Date
Encryption: Base 64 Decode
Encryption: Base 64 Encode
Encryption: Decrypt Symmetic
Encryption: Encrypt Symmetric
Encryption: GUID
Encryption: MD5
Encryption: SHA1
Encryption: SHA256
Encryption: SHA512
HTTP Get
HTTP Post
HTTP Post 2
HTTP Request Header
HTTP: Is CHTML Browser
HTTP: Redirect To
HTTP: URL Encode
HTTP: Wrap Long URL
Math: Add
Math: Divide
Math: Format Currency
Math: Format Number
Math: Mod
Math: Multiply
Math: Random
Math: Subtract
Microsoft Dynamics CRM: Add MSCRM List Member
Microsoft Dynamics CRM: Create MSCRM Record
Microsoft Dynamics CRM: Describe MSCRM Entities
Microsoft Dynamics CRM: Describe MSCRM Entity Attributes
Microsoft Dynamics CRM: Retrieve MSCRM Records
Microsoft Dynamics CRM: Retrieve MSCRM Records Fetch XML
Microsoft Dynamics CRM: Set State MSCRM Record
Microsoft Dynamics CRM: Update MSCRM Records
Microsoft Dynamics CRM: Upsert MSCRM Record
Salesforce: Create Salesforce Object
Salesforce: Long SFID
Salesforce: Retrieve Salesforce Job Sources
Salesforce: Retrieve Salesforce Objects
Salesforce: Update Single Salesforce Object
Sites: Authenticated Employee ID
Sites: Authenticated Employee Notification Address
Sites: Authenticated Employee Username
Sites: Authenticated Enterprise ID
Sites: Authenticated Member ID
Sites: Authenticated Member Name
Sites: Cloud Pages URL
Sites: Is Null Default
Sites: Live Content Microsite URL
Sites: Microsite URL
Sites: Query Parameters
Sites: Redirect
Sites: Request Parameter
Social: Get Published Social Content
Social: Get Social Publish URL
Social: Get Social Publish URL By Name
String: Char
String: Concat
String: Format
String: Index Of
String: Length
String: Lowercase
String: Propercase
String: Reg Ex Match
String: Replace
String: Replace List
String: String To Date
String: String To Hex
String: Substring
String: Trim
String: Uppercase
Utilities: Attribute Value
Utilities: Domain
Utilities: Empty
Utilities: IIF
Utilities: Is Email Address
Utilities: Is Null
Utilities: Is Phone Number
Utilities: Output
Utilities: Output Line
Utilities: V
AMPscript Update, Insert, and Delete Calls Processing During Sending
Impression Tracking
DateDiff
Overview
Returns the difference between two dates.Syntax
DateDiff(1, 2, 3)
| Ordinal | Type | Description | |
|---|---|---|---|
| 1 | Date | Required | Starting date for comparison using either MM/dd/yyyy or YYYY-MM-DD format |
| 2 | Date | Required | Date to subtract from starting date using either MM/dd/yyyy or YYYY-MM-DD format |
| 3 | string | Required | Unit of time of the difference. Valid values include Y, M, D, H, or MI |
Usage
%%=DateDiff(@tomorrow,@today, 'D')=%%System returns: 1
Last Updated: Jun 8, 2021