cancel
Showing results for 
Search instead for 
Did you mean: 

first and Last Date of a Month

Former Member
0 Kudos

Hi Experts, I need  first  and last date in a month, for example 11/01/2014(mm/dd/yyyy) and  11/30/2014, PLease let me know how to achieve this Thanks

View Entire Topic
Former Member
0 Kudos

Hi ,

You can get the first day of the month using below function.

add_months(last_date(sysdate()), -1) + 1

Thanks,
Ancy

former_member208363
Active Participant
0 Kudos