Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT OrderId, SubscriberKey, EmailAddress, CancelledAt, Fulfillment, UpdatedAt FROM [OrderDE] WHERE Fulfillment = 'fulfilled' AND CONVERT(datetime, UpdatedAt) <=DATEADD(hour, -1, CONVERT(datetime, GETDATE())) AND CONVERT(datetime, UpdatedAt) >= DATEADD(hour, -2, CONVERT(datetime, GETDATE()))
Add Comment
Please, Sign In to add comment