Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Where [Date] > MakeDate(2018,7,8) ;
If I understand right the syntax above says if the [Date] field is greater than 7/8/2018 then load the data. How could I modify it to say if the [Date] field is in the current month then load the data?
First Option
Let vCurrentMonth = Date(Today(),'MMM-YYYY');
Where Date(YourDateField,'MMM-YYYY') = '$(vCurrentMonth)'
Or Second option
Where Date(YourDateField,'MMM-YYYY') = Date(Today(),'MMM-YYYY');