Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 11:00 AM (PST)
Microsoft Tech Community
SOLVED

Find Last Day of Next Month

Steel Contributor

Hello Experts,

 

I am trying to find the last day of next month from a date (ie FundDate)

I am using this: 

LastDayNxtMo: DateSerial(Year([FundDate]),Month(DateAdd("m",1,[FundDate]))+1,1)-1

==>BUT IT IS WRONG.  

here is the output:

you can see that when the FundDate is December then it returns January of same year and not the next year.  

Tony2021_0-1653871857274.png

 

I have attached a database if needed.  

 

thank you

2 Replies
best response confirmed by Tony2021 (Steel Contributor)
Solution
DateSerial(Year([FundDate]),Month([FundDate])+2,0)
Perfect! thank you Arnel.
1 best response

Accepted Solutions
best response confirmed by Tony2021 (Steel Contributor)
Solution
DateSerial(Year([FundDate]),Month([FundDate])+2,0)

View solution in original post