Skip to Content
Author's profile photo Arjun Rao
Arjun Rao
November 27, 2014 Less than a 1 minute read

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



Assigned Tags

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