find end of month - Answers - Salesforce Trailblazer Community
Trailblazer Community
Ask Search:
Pete FifePete Fife 

find end of month

On a current project where I'm getting current month to date data, ever day.

I then load it into SFDC.  I soon realized I'm unable to run a report to get a Month End numbers over the current year.  This is because it would take all of Jan daily loads and summeriz them.  What I needed was to identify how to calculate what day is the end of the month.

I found this answer by googling, and after a bit of filtering.. and came across this post by Salesforce Made Easy, author Zishan Razzaq.  

I was able to take his formula for finding the last day of the month, then compare that against my daily transaction date to tell me if that is the last record for the month, ie giving me my total month end date.

From there I can run a report to show any of those dates which equals end of the month, and the current transaction date.  Thanks Zishan!
Best Answer chosen by Moderator (salesforce.com) 
Pete FifePete Fife
can I answer myself?

All Answers

Pete FifePete Fife
can I answer myself?
This was selected as the best answer
Michael King Ezioha SomtooMichael King Ezioha Somtoo
ZenPens is an online publishing platform where you can read, write and publish short stories, poems, articles and novels. Just register as a writer and start publishing or if you are a reader, read on!
 
Read online stories and poems. (https://www.thezenpens.com)