4. Select Orders from the last 6 months

note the scenario below uses data from the deselect demo data package see docid 5 cozdtg0nwmlmeufrmbz scenario you want to get the orders that were placed in the last 6 months https //www youtube com/watch?v=quwwg2ydwzk\&list=plfs7 dts7jwyhwe scy5z4qvgbh2ilspj\&index=4 or follow the steps below 1\ input on the selections overview screen, click on new selection to create a new one drag data extension deselect demo orders to the selected data extensions section drag field order date to the selected filters section criteria is after or on select relative value 6 , months , before now 2\ output hit the create data extension button, enter a name, eg orders from last 6 months, and press save select the following fields by either double clicking on them or dragging them to the section on the right id and order date from deselect demo orders click save data extension 3\ preview when you click run preview on the preview screen, a results table will be shown with fields id and date from deselect demo orders the results table shows only orders from the last 6 months note we did not enter an exact date; whenever we run this selection, we'll always get orders from the last 6 months as the date comparison is dynamic and based on the time of execution of the query