Forum Discussion
Tony2021
May 30, 2022Steel Contributor
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
- DateSerial(Year([FundDate]),Month([FundDate])+2,0)