cancel
Showing results for 
Search instead for 
Did you mean: 

How to get Previous Month Start date and End Date?

NagaYaparla
Level 4
Hi All, How to get Previous month start Date and End date. If anyone knows Please reply to this post, it's helpful to me. Thanks in advance!
2 REPLIES 2

MichalSzumski
Level 6
Hi Yaparla,   I probably overcomplicated this but it should work: Previous month start date: ToDate(FormatDate(AddMonths(Today(),-1),"yyyy/MM")) Previous month end date : AddDays(ToDate(FormatDate(Today(),"yyyy/MM")),-1)   Hope this helps   Best regards Michal Szumski

NagaYaparla
Level 4
Thank you.. It's Working.