I have an email to send once in the morning and once in the afternoon.
What I would like to do is identify the current time of day when someone enters the journey, so I can use a decision split to determine whether to send the Morning email (at 9:30am) or the Afternoon email (at 3:30pm).
So, when a record qualifies for the journey I want Journey Builder to see that they entered at 8am and therefore send the Morning email at 9:30am first, then wait until 3:30pm to send the Afternoon email. Or, if the record enters at 9:31am then wait until 3:30pm to send the Afternoon email. I hope this makes sense.
What would I need to do to achieve this?
Hi, @Greg Beazley
> If I use a Decision Split and reference that DateTime field I am only presented with an option to segment by Date, and not Time.
Yes, that's right.
Since you have DateTime field... could you set the Path(text) field on entry source DE? Beforehand, insert the value of A or B on Path filed by SQL query activity of Automation Studio.
The query sample:
, case when concat(datepart(hh,datetime),':',datepart(n,datetime)) >= '9:30' and concat(datepart(hh,datetime),':',datepart(n,datetime)) < '15:30' then 'B' else 'A' end as [Path]
And use the Path(text) field on Decision Split.
