Hello,  I'm trying to get a count of all the profiles on my dataset where the DOB is less than 21 years old from the Current Date. I'm trying to use the following syntax in the Query service but get an error:  SELECTperson.birthDate AS birthDate,COUNT(1) eventCountFROMdataset_aep_coreprofileWHEREDAT...

@somasundaram_h - you will need to contact Adobe Support and ask them to add this to your instance. From what they told me, it was on the previous versions but was somehow removed when they updated v7. They will also provide a link to the documentation as well once added.  I'm not sure if this has b...

@SatheeskannaK @dugganab - I took the approach outlined above where I created an Audience of profiles that received a Welcome, and will check their login date to see if it falls within the date range needed to send the corresponding email. 

Hello,  In my journey where a profile enters via an Event and is sent a Welcome email. Then, after a 30 day wait, I'm required to check to see if the profile has logged in to the app. If they haven't logged in since the initial Welcome, then they are sent a Re-engage.  It would be nice for AJO to ha...

All,  I have a client that would like to italicize a portion of their email Subject Line. I've tried to use a few options (Cntl+I ; <i></i>), but none seem to work. Does Email Designer not offer any font options for the SL?   

All,  I How do I load an .ics file into AJO or Experience Manager Assets so I can get the link for it. Based on the documentation is a previous post,  they say load to my ESP (AJO) and get the link. I've tried a few methods and the closest I get is a shared link that doesn't work.  If AJO has the ca...

Hello,  I'm just trying to figure out the easiest way for me to get a count of Country Codes that exist in an Audience I created. I tried using the Query Service, but that was very confusing, and not sure it queries Audiences. Can someone please guide me in how I can just easily understand how to co...

@_Manoj_Kumar_  Thank you for the code. I implemented it and I can see when the winning Delivery is selected the Target Approval is checked. However, the Delivery still only shows me 'Confirm delivery' and no option for 'Target Approval'.  I was hoping that since this was going to a prepared status,...

All - question. When running the A/B test in Adobe - once the winner is picked, is there a way to configure the Delivery so that both Target Approval and Confirm Delivery can be set up. My client is wishing to approve the Audience for both the test emails - which is easy enough since I'm using a sin...

Hello,  I created a delivery using the wave function. The delivery has started, but I need to change 3 waves. Is there a way to do this without the process of stopping the delivery, removing previously sent records, and starting the delivery over again?