Forum Discussion

Tony2021's avatar
Tony2021
Steel Contributor
May 30, 2022

Find Last Day of Next Month

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.  

 

I have attached a database if needed.  

 

thank you

Resources