Extract data based on the date

[#1]

Hi All

Can some one please help me in writing the expression to extract the data only if the below condition matches

a)If the date selected is between the month i.e., in the middle of the month data has to be displayed for the last month and not the present month

Thanks and Regards

D Swathi

[khalander]

Hi,

Please follow below process

let vLastMonthEndDate=MonthEnd(Today(),-1);

select * from

Table

where date <= 'vLastMonthEndDate';

[Anonymous]

Could you please elaborate your requirement.

As per my understanding if the user clicks on the date field i.e middle of the current month(or any selected month) then data should be displayed  last month .

If so, try this ,

let VmaxDate = Date(Max(Date)-1);

let VMonthEnd = MonthEnd(Date(Max(Date)));

In Script

Select * FROM

WHERE DATE >= 'VMaxDate' and Date ='VMonthEnd';