Hi,

(ORACLE) I am given a date variable of 'ActivateDate' and I need to create a query in which I only get back data where the 'ActivateDate' is in the previous month from the current sysdate.

For example, if I run the query now I need to get data back in which the 'ActivateDate' is between April 1 12:00:00 AM and April 30 11:59:59 PM. Any suggestions on how to do this as I am not sure of the syntax?

Thanks