Query transactional message delivery logs

[GMar]

Hello everyone,

I would like to extract the delivery logs of a transactional message whose event date is 22 days ago. To do this, I used the formula @eventdate=DateOnly(DaysAgo(22)), like the one suggested by ACS in the advanced mode. Unfortunately, this formula does not produce any results, even though I know that there are messages sent on these dates. However, if I use the options in simple mode, the query produces results. It seems that ACS does not understand the above formula, but I need to target messages sent on that specific day.
Do you have any suggestions for achieving my goal?

Thank you for your help,

G

Translated with www.DeepL.com/Translator (free version)

[SatheeskannaK · Accepted solution]

Hi @GMar,

You will have to use the formula like below,

DateOnly(@eventdate) = DateOnly(DaysAgo(22))