Skip to Content

First and Last Date of a current and Previous Months

FirstDay_PrevMonth: add_months(last_date(sysdate()), -2) + 1

LastDay_PrevMonth: last_date( add_months(sysdate(),-1))

/wp-content/uploads/2014/11/1_595963.png

First day of the current month:add_months(last_date(sysdate()), -1) + 1

Last Day of the current month : last_date(sysdate())

/wp-content/uploads/2014/11/2_595977.jpg



Be the first to leave a comment
You must be Logged on to comment or reply to a post.