I need to fetch data until previous month end

[varadha72]

Hi

Can someone help me here, I need to fetch/filter data in record selection to return data until previous month end.
Current Date- 9/2/2014
Data Fetch- Until 8/31/2014

Please correct me if this is incorrect-
Sample_date}<=DateSerial(Year(currentdate), Month(currentdate), 1)-1;

Thanks

 

[hilfy]

That should work.

-Dell

DecisionFirst Technologies - Seven-time SAP BusinessObjects Solution Partner of the Year

http://www.decisionfirst.com

 

[varadha72]

Thanks Hilfy