Quintiq file version 2.0
|
#parent: #root
|
Method GetLastMonth (
|
DateTime timestamp
|
) as DateTime id:Method_Kpi_GlobalState_GetLastMonth
|
{
|
#keys: '[136398.1.809533354]'
|
Body:
|
[*
|
// Returns the timestamp with its month reduced by 1.
|
// Takes year-crossing into account.
|
|
timezone := TimeZone::ObjectTimeZone( KpiTracker );
|
|
out := timestamp.StartOfMonth( timezone )
|
.AddAsPeriod( timezone, -Duration::Days( 1 ) )
|
.StartOfMonth( timezone )
|
.AddAsPeriod( timezone, timestamp - timestamp.StartOfMonth( timezone ) );
|
|
if( out.StartOfMonth( timezone ) = timestamp.StartOfMonth( timezone ) )
|
{
|
// When it is 29-31 March, the Feb do not have those dates, then just get Feb 28
|
out:= timestamp.StartOfMonth( timezone ).AddAsPeriod( timezone, -Duration::Days( 1 ) );
|
}
|
|
return out;
|
*]
|
}
|
