Leveraging Intelligent Recommendations for Operational Transformation. AMS Partners click HERE | EMEA/APJ Partners click HERE |
05/08/2024 04:57 PM
Hello,
I am using LASTLOGONDATE > CURDATE() - 30 in the account query for the user manager campaign to certify accounts. However, after launching the certification, it reports 0 records, even though we have existing accounts.
Thanks,
Deepu
05/08/2024 07:50 PM
@Deepu please share report SS ?
05/08/2024 08:35 PM
Please validate if accounts are coming from data analyzer.
select name,LASTLOGONDATE from accounts where LASTLOGONDATE is not null and LASTLOGONDATE > CURDATE() - 30 and status=1
05/08/2024 10:34 PM
Yes it is coming
05/09/2024 03:21 AM - edited 05/09/2024 03:21 AM
Hi @Deepu ,
Can you try the below code in your campaign account query:
LASTLOGONDATE>CURDATE() - interval 30 day
If this helps your answer, please consider selecting Accept As Solution and hit Kudos
05/09/2024 06:07 AM
same issue, zero records it is showing but when i run data analyzer I have data
05/09/2024 07:30 PM
Could you kindly provide a detailed snapshot of the information extracted from the logs, encompassing errors and other pertinent functionality details encountered during the execution of this process? Your assistance in furnishing this information would greatly aid in the analysis and resolution of any issues .