1

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?

Improve this question
4
  • 1
    You likely will need to do so via a Query and not the UI filter functionality.
    – Gortonington
    Jun 12, 2017 at 17:08
  • I'm new to exact target. Are queries the same as a Data Extract?
    – Carlos Blanco
    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/…)
    – Gortonington
    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.
    – Gortonington
    Jun 12, 2017 at 19:59

1 Answer 1

Reset to default
1

You can use this

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

Improve this answer

You must log in to answer this question.

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