Search results

Try this in a calculation AddDays(FormatDate(AddMonths(Today();+1);"yyyy-MM-01");-1) Explanation : Add one month to today's date / Format the result to first day of month / Subtract one day from the result (add minus one) For any other date : replace Today() with a declared variable : [date]...