
I'm trying to create a variable that holds the number of days in any given month. This app will ideally be used into the future. So I want to be able to write something that I won't have to maintain (go in and change the variable over and over again throughout the months and years). Is there a function that grabs the amount of days in a month?
Thank you,
I don't know if there is an easier way, there always is, but this is what I come up with.
Day(DateAdd(DateAdd(Today(),1,Months),-Day(Today()),Days))
Adding a Month, then Subtracting the current date days, and getting the day leftover.