@DavidRoss91 - that code was 99% accurate. Here's the final code that worked: SELECTperson.birthDate AS birthDate,COUNT(1) AS eventCountFROMdataset_aep_coreprofileWHEREperson.birthDate + INTERVAL '21 YEAR' > CURRENT_DATEGROUP BYperson.birthDate;  The code didn't like 'years' syntax. YEAR is the synt...

@SatheeskannaK - Thank you for the feedback, but that's not that same as creating and *.ics file. That's creating the links based on ESP (which is what I've done as a work around). I had to create the links for each ESP and then write HTML coding to dynamically switch to the calendar based on ESP.  ...

@SatheeskannaK - that's the issue. The process says "...get the ICS file you created in step 2 using the iCalendar Event Maker tool. Then, upload it to your company’s servers, content management system (CMS), or email provider’s media library."  Experience Asset Manager (along with AJO) is not allow...

@SatheeskannaK thank you for your response. Your post is what I have linked in my question, also where the screenshot I supplied. The post speaks to Litmus and not Adobe. I tried loading the .ics files into AEM Asset Manager to get the link I need for HTML coding, but it does not seem to work. Asset...

Hello,  I created a Subscription List and attached it to a LP. The LP is designed to the Opt-In to a service. I subscribed myself to the list. What I'm also trying to do is once I subscribe, I would like the Language field on my profile to update - add value 'FR' or 'French' to that field.  When loo...

@SatheeskannaK - I have the same question - but wondering would a better alternative be to just create the Non-English version as a landing page with AJO, and then in the English email have text read '[Language] Translation' and link it to the LP where you have the other language version?  

Hello,  I tried this code for an Audience I needed to build and it yielded 0 records. However, when I configured my Event f to use JourneyAction ID (using the MessageID # as the input for the search), I was able to get the records needed for the Audience.Did something change in AJO where JourneyActi...