How to code two fields with dates at the same time?

User_LGSZT

Currently in my query that I have set up I have two date data points that I want to use separate but at the same time. One for MTD (Month to Date) and the other is YTD (Year to date). Each date needs to be in it's own separate column.

The field original formula is "OE_Lines"."SHIPPED_QUANTITY" (but I want to code this in a way that I can also pull the Date measurement with it for each date.) How would this be possible?

I can specify the date by using a filter. However since this is just a filter, it sets this for both fields in the query instead of each date measurement. Example this allows me to see last month:

"OE_Lines"."SHIPPING_DATE" >= EVALUATE('prior_month_begin_date') and "OE_Lines"."SHIPPING_DATE"< = EVALUATE('prior_month_end_date)