+ Start a Discussion

How do I get Last 30 Days in a SOQL Statement (Getdate(), Today()???)

I am trying to create a SOQL Statement to get data from the last 30 days

For example, I would do this on SQL Server by writing:

Select * from case where createddate > getdate -30

Is there a similar way to keep this in place with SOQL.

I have tried GetDate()-30, Today()-30 but no luck.

Best Answer chosen by Admin (Salesforce Developers)

EIE50
Hi Dave,

Do try this,

Select * from case where WHERE CreatedDate = LAST_N_DAYS:30

Thanks

EIE50
Hi Dave,

Do try this,

Select * from case where WHERE CreatedDate = LAST_N_DAYS:30

Thanks

This was selected as the best answer

cactusdave
Thanks. This worked perfectly.

Need an account? Sign Up

Have an account? Sign In