I have a data extension with a date field. I want to create a filtered data extension that filters data for the past hour. Can I create a filer that filters on the time part of the date field?

  • 1
    You likely will need to do so via a Query and not the UI filter functionality. Jun 12, 2017 at 17:08
  • I'm new to exact target. Are queries the same as a Data Extract? Jun 12, 2017 at 17:15
  • 1
    A query is basically just a SQL select statement run against a Data Exension or Data View (help.marketingcloud.com/en/documentation/exacttarget/…) Jun 12, 2017 at 17:30
  • 2
    To help others with the same question, it would be great if you could put a sample of your full solution as an answer to your question. Jun 12, 2017 at 19:59

1 Answer 1


You can use this

select [field_target ]from [DATAEXTENSION ]WHERE [DATETIME FIELD] >= DATEADD(hour, -1, GETDATE())

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .