laura.mays Posted October 8, 2019 Share Posted October 8, 2019 If Today is 10/7/2019 how do I calculate the 1st day of the prior month (9/1/2019) in the AdHoc editor? Link to comment Share on other sites More sharing options...
C-Box Posted October 8, 2019 Share Posted October 8, 2019 Take a look here... there I described how to set a default value for the last day in last month (something similiar to your question) using the shipped with Apache Library for the DateUtils.https://community.jaspersoft.com/questions/1122406/expression-editor-last-day-last-monthhth + regardsC-Box Link to comment Share on other sites More sharing options...
danoldenkampgmail.com Posted October 8, 2019 Share Posted October 8, 2019 First Day of last month:new SimpleDateFormat("yyyy-MM-dd").format(java.util.Date.parse((MONTH(NOW( )) -1 ) + "/1/" + YEAR(NOW())) ) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now