Skip to content

sprignaturemoves

the personal blog of adam spriggs

  • Home
  • About Me
  • Salesforce Marketing Cloud
    • Known Issues
    • AMPscript Syntax Highlighter for Sublime Text
    • All SFMC Posts
    • AMPScript
    • API
    • Automation
    • Journey Builder
    • Server-side JavaScript
    • SQL Queries
  • The AMPscript Guide
  • Coffee
    • Coffee Prep
    • Empty Coffee Bags
  • Dadverbs

LEGO Town Interruption

Posted on2013-05-032022-01-04 Categoriesfun, LEGO

Pittman Drive Crusher

Posted on2013-05-022021-04-12 Categoriestechnology & science

via likecool

Daft Punk on Piano

Posted on2013-05-022022-01-04 Categoriesmusic

Days between T-SQL Dates

Posted on2013-04-222017-07-30 CategoriesSalesforce Marketing Cloud, SQL Queries

Suppose you’d like to select subscribers from an Salesforce Marketing Cloud data extension that were created in the last thirty days. Here’s what I use:

or between two static dates:

For further reading:

  • Query Activity
  • T-SQL dateadd() function

Patton Oswalt’s Star Wars Filibuster

Posted on2013-04-192022-02-03 Categoriesfun, nerdery

Patton Oswalt’s Star Wars Filibuster on Parks and Recreation. This is so epic.

Posts navigation

Older posts
Newer posts
Search
Post Categories

Where to Find Me

  • BitBucket
  • Facebook
  • GitHub
  • Last.fm
  • LinkedIn
  • Pinterest
  • StackExchange
  • X

Popular Posts

  • AMPScript Lookup Examples
  • Retrieving and Starting an Automation with SSJS
  • Journey Logging using Update Contact
  • One-Click Unsubscribe with AMPscript
  • Troubleshooting Queries in SFMC
  • Updating Salesforce Objects with Server-Side JavaScript
  • Determining Business Unit Subscriber Status
  • Coupon Claiming in AMPscript
  • Timezones in SFMC
  • Geolocation in the Salesforce Marketing Cloud

My Favorite Things

  • Crema.co
  • Bucks
  • The AMPscript Guide
  • PK Grills
  • Smith & Wesson
United States Flag
06.24.22
Copyright © 2026 sprignaturemoves. All Rights Reserved.
Catch Starter Child Theme by Adam Spriggs
Scroll Up