Quintiq file version 2.0 #parent: #root Method GetLastSundayOfDataBroker () as DateTime id:Method_LibDEF_DialogEditEventCleanupDaemon_GetLastSundayOfDataBroker { #keys: '[143398.0.685637724]' Body: [* // Get the Last Sunday based on DataBroker's timezone. value := DateTime::Now(); timezone := TimeZone::Construct( this.GetUserTimeZoneID() ); // get Sunday var_sunday := DateTime::Now() - Duration::Days( DateTime::Now().DayOfWeek( timezone ) ); // get the start of Sunday at 0000hr UTC, then offset by the user's Timezone when Timezone mode is enabled. value := var_sunday.StartOfDay( timezone ); return value; *] }