Query transactional message delivery logs | Community
Skip to main content
G
GiustaMa
Level 2
January 31, 2023
Solved

Query transactional message delivery logs

  • January 31, 2023
  • 1 reply
  • 698 views

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)

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by SatheeskannaK

Hi @giustama,

 

You will have to use the formula like below,

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

1 reply

SatheeskannaK
Community Advisor
SatheeskannaKCommunity AdvisorAccepted solution
Community Advisor
January 31, 2023

Hi @giustama,

 

You will have to use the formula like below,

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

Thanks, Sathees
    Terms & ConditionsAccessibility statement

    Loading footer...