Skip to content

Instantly share code, notes, and snippets.

@mpstenson

mpstenson/custom_field_date_comparison.sql

Created November 21, 2016 20:27
Show Gist options
  • Save mpstenson/7ace79cb1e57cb8de7a33c3960264aac to your computer and use it in GitHub Desktop.
Save mpstenson/7ace79cb1e57cb8de7a33c3960264aac to your computer and use it in GitHub Desktop.
Download ZIP
Compare a custom field's date (plus an offset) to the current date
Raw
custom_field_date_comparison.sql
dateadd(MINUTE,10,dateadd(S, Custom1, '1970-01-01')) < GETUTCDATE() and Custom1 <> 0;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment