How to write this query to extract records with date fields

[gnewuser]

I have a scoped application and a scheduled job where I am writing a query to get all the records that would pass the below condition:

IToday is within 30 days of the start date, and if today is before the start date

How do I do the within 30 days of the start date and also check if today is before the start date.

Thanks so much

[SanjivMeher]

You can build a query in the condition builder as below and then copy this query and use in an EncodedQuery in scheduled job

[gnewuser]

Thanks so much . for me the date field has a value of 2024-04-12 and that particular record doesnt show up when I apply the above query.

[SanjivMeher]

Can you post a screenshot of how you are using it?