Irsmalik,
I’ve moved your post to a new thread, as it really should be a new discussion.
Based upon your query, it should work. However, I noticed that you are sorting your results by the TDate, which implies that you have multiple dates in your results. However, if you do not have any
ClassName that fall on
exactly TDate - 30, then you will get no results.
Perhaps your Criteria expression should be:
- WHERE DM.TDate >= Date()-30
This would return all records from within the past 30 days.
However, you do not describe how your query “is not working” so this is just a guess.
Hope this hepps.