add date condition

Summary:

Hi Everyone,

I need your assistance in regards to add a date condition in analysis.

I have to add a condition in the where clause and want out those positions. the condition is "All position should be taken out of the report one month after hiring date".

SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';SELECT
   0 s_0,
   "Recruiting - Recruiting Real Time"."Job Requisition - Basic Information"."Requisition Id" s_1,
   "Recruiting - Recruiting Real Time"."Job Requisition - Basic Information"."Requisition Number" s_2,
   "Recruiting - Recruiting Real Time"."Worker"."Enterprise Hire Date" s_3,
   "Workforce Management - Position Real Time"."Department"."Department Name" s_4,