## Assigning Quarter to a DateTime

0
Does the following look like it should correctly assign quarter to a datetime field? I’m finding quarter incorrectly assigned, e.g., where month is correctly set to 7, quarter is 3?   if  parseInteger(formatDateTimeUTC(\$Iterator_MTDHist/mindt,'MM')) <= 3 then 1 else if parseInteger(formatDateTimeUTC(\$Iterator_MTDHist/mindt,'MM')) <= 6  then 2  else if  parseInteger(formatDateTimeUTC(\$Iterator_MTDHist/mindt,'MM')) <= 9  then 3  else if parseInteger(formatDateTimeUTC(\$Iterator_MTDHist/mindt,'MM')) >= 10  then 4  else 0
2

Hey SL,

The way you compare the month from date is perfectly good. But, you have given only the top range for quater and didn’t mention anything for the start range. so, the condition here should be

if
parseInteger(formatDateTimeUTC(\$Iterator_MTDHist/mindt,'MM')) <= 3 then 1

else if

parseInteger(formatDateTimeUTC(\$Iterator_MTDHist/mindt,'MM')) >3  and
parseInteger(formatDateTimeUTC(\$Iterator_MTDHist/mindt,'MM')) <= 6  then 2
else if
parseInteger(formatDateTimeUTC(\$Iterator_MTDHist/mindt,'MM')) >6  and
parseInteger(formatDateTimeUTC(\$Iterator_MTDHist/mindt,'MM')) <= 9  then 3
else if
parseInteger(formatDateTimeUTC(\$Iterator_MTDHist/mindt,'MM')) >= 10  then 4
else 0

Note:  If you are calculating using UTC time. Make suer you have set the attribute’s localize property to NO .

In accurate way of doing this replicate the same condition check inside a Java Action where you can get the month value with this code.

2

All those ifs can go out the window. Always try to use as little cylces as possible and stay in Mendix and out of Java if you can. This task can get solved with one statement:

``floor(trimToMonths(\$Iterator_MTDHist) div 3)+1``

And always, if you not 100% certain of the correctness: build a unittest for it.

0

or has anyone found a more reliable way to assign month and quarter to a datetime field?

0

Sorry no dice on the suggestion – I added the lower bounds but am still ending up weird values, e.g., month 7 mapping to quarter 2. I actually see evidence that the same date is being assigned different quarters. Any idea on this? I’m not familiar how to incorporate a JAVA action, so not sure how to go about that.