@bamamh1 this is how I would do it : Monthly Scheduler running on 5th day of each monthQuery following profilesAge is equal to 6465th birthday is in 4 months : MonthsDiff(GetDate(), AddYears(@birthDate, 64)) = 4Email deliveryHope this helps.

Will the ACS Experience Cloud Triggers still be available in V8 UI too?

Hello there.How long will it take, for objects created in the web UI, to be synced with ACC rich client and vice versa?

Hi @filipe23353816  This is correct, you can't apply the replace function for a string over 255 chars in an enrichement activity.One workaround solution is to use the export file activity upload to your ACS sftp and load the file again. Add a fork activityUse your replace function inside the export ...

Hi,This is my understanding :For your 10 services you need the latest subscription history record for each profile.Then, since some profiles share the same ID, you want to keep only one sub histo record per service and profile ID, the one with the latest date.This is how to do it :Query Subscription...

Hi @Parth1 ,Your request is not totally clear to me.Are you trying to get the following : For each profile, and each service, the latest subscription history record? (even if the profile is not subscribed to the service anymore?)Then you want the result aggregated into one line?How many services you...

If you look at your complete loadfile activiy log you should see that it actually ran as many times as they were files loaded. In your case 15 times.This is what happens when the fileTransfer activity downloads more than one file.The rest of the workflow loops in sequence where each activity execute...

I don't believe it's possible out of the box via the available reports.But you can create a workflow to calculate the number of opens at each hour across all your recurrent deliveries of your campaign. Query Tracking logs of type open for you specific campaignUse the Hour function to get the log dat...

What it means is that you can use the value $(vars/@filenames) in an enrichment to get all the file names from your file transfer (separated by '\n', as newline).  Please note that if the total number of chars from your enrichment is above 255, it will trigger an error.You can still use the function...

Hi @Parth1, You can use a combination of Replace (replace pipe as line return) and GetLine functions in an enrichment to do this.For example : GetLine(Replace(subject, '|', '\n'), 1) should give you the first value 'Maths' of your pipe separated stringYou will have to do that for as many subjects or...