topic Load data current month in App Development

Load data current month

brucemeyers — Tue, 23 Oct 2018 02:23:26 GMT

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?

Re: Load data current month

nasirsaikh — Tue, 23 Oct 2018 04:42:20 GMT

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');