account query issue campaign

[Deepu]

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

[Raghu]

@Deepu  please share report SS ?

[rushikeshvartak]

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

[Deepu]

Yes it is coming

[PremMahadikar]

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

[Deepu]

same issue, zero records it is showing but when i run data analyzer I have data

[rushikeshvartak]

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 .