Navision-Girl.Com: CM will return the last day of a month.

Tuesday, 19 December 2006

CALCDATE ('CM', date) will return the last day of the month.

To get the first day of the month,
use CALCDATE ('CM-1M+1D', date);

Unknown said...: CALCDATE('-CM',Today) will give correct result of First day of month; 8 December 2009 at 23:31:00 GMT-8
Unknown said...: Thank you!; 25 February 2011 at 11:10:00 GMT-8
Akhilesh said...: thanks; 21 September 2011 at 23:42:00 GMT-7
Anonymous said...: Thank you for this!; 4 May 2012 at 07:15:00 GMT-7
Tio D said...: I actually received the wrong date with the original calculation. When trying to calculate the first day of November (the current month) I used the formula from the OP and got 10/31/2015. As best I can tell the "-1M" only does 30-day increments, so I ended up with the calculation:

11/30/2015 - 30D + 1D = 10/31/2015.

The follow up post that recommended using -CM worked perfectly.; 13 November 2015 at 12:29:00 GMT-8