# Date  Question?

**URL:** <https://www.dynamicsuser.net/t/date-question/5368>\
**Category:** Developers Forum\
**Created:** [September 28, 2001, 4:00pm UTC](https://www.dynamicsuser.net/t/date-question/5368 "2001-09-28T16:00:15Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![mblauer](https://avatars.discourse-cdn.com/v4/letter/m/c67d28/32.png) [@mblauer](https://www.dynamicsuser.net/u/mblauer)\
**Post date:** [September 28, 2001, 4:00pm UTC](https://www.dynamicsuser.net/t/date-question/5368/1 "2001-09-28T16:00:15Z")

</div>

Why does start:= ‘CM-1M+1D’; SDATE2 := CALCDATE(start); return the date 8/31/01 and not 9/1/01? thanks

---

<div class="post-metadata">

**Author:** ![reijer](https://avatars.discourse-cdn.com/v4/letter/r/d07c76/32.png) [@reijer](https://www.dynamicsuser.net/u/reijer)\
**Post date:** [September 28, 2001, 6:18pm UTC](https://www.dynamicsuser.net/t/date-question/5368/2 "2001-09-28T18:18:07Z")

</div>

Hi Blauer, according to the C-SIDE Reference Guide interprets the system the string from left to right, one subexpression at a time. Today → 9/28/01 CM → 9/30/01 -1M → 8/30/01 +1D → 8/31/01 If you want to have the first day of the month try the following: **CALCDATE(‘-1M+LM+1D’)** or **DMY2DATE(1)** Regards, Reijer

---

<div class="post-metadata">

**Author:** ![apertierra](https://avatars.discourse-cdn.com/v4/letter/a/bcef8e/32.png) [@apertierra](https://www.dynamicsuser.net/u/apertierra)\
**Post date:** [September 28, 2001, 11:10pm UTC](https://www.dynamicsuser.net/t/date-question/5368/3 "2001-09-28T23:10:05Z")

</div>

or start := ‘-CM’; -CM on a calcdate returns the start of current month. – Alfonso Pertierra apertierra@teleline.es Spain Western Computer Los Angeles, California