Thanks JonWhen you say "truncate the right hand side so it’s a day", what syntax is needed to do that exactly?Many thanksTom

So, I've put this into the email, but it's incorrect.  It's failing to proof.  Can anybody point out where I've gone wrong please?<% if ( recipient.firstName IS NULL ) { %>You're almost there!<% } else { %> <%=recipient.firstName %>, you're almost there!<% } %>

Thank you, is there an equivalent of this in Adobe Campaign Classic?

Thank you, that worked.  Sorry for being slow on that one.Can you help me with one more thing please?I went to add an extra filter item, I only want people with an Event date of 3 days ago.  The Event date field is date & time though, so when I select "today minus 3 days" nothing is selected.  What ...

I'm using BroadLogRcp and targeting as Recipient yes.I've run the query to output where Primary Key is not empty, and that has confirmed that I have data in this table.Within this result I can see the emails that I'm trying to filter by...However, when I then update the main query to Label contains ...

Thank you.I'm trying to get all email addresses who were sent an email with "buy" in the Delivery Label.Here it is in the data.  And here is my query.I'm getting no records though.  Is it because of the way that Buy is formatted in the Value field or something?Thanks

ACCThanksTom

Hello Rajesh, I've since found out that you can only edit Dimensions in Cube Reports in Adobe Campaign if you're also signed up to Adobe Analytics - which we're not.I need to edit the Dimensions in this pre-loaded Cube in order to get the date to display.Therefore, this doesn't help me unfortunately...

Great, thank you.  How can I add in sent date to this report?  Also, how can I filter by date?

Thank you Rajesh.Just to confirm, are these possible to build in Campaign?  Or only in Adobe Analytics?ThanksTom