Codeunit 358 DateFilter-Calc
src/Layers/W1/BaseApp/Foundation/Period/DateFilterCalc.Codeunit.al82 lines, Copyright (c) Microsoft Corporation. MIT
// ------------------------------------------------------------------------------------------------// Copyright (c) Microsoft Corporation. All rights reserved.// Licensed under the MIT License. See License.txt in the project root for license information.// ------------------------------------------------------------------------------------------------namespace Microsoft.Foundation.Period;using System;codeunit 358 "DateFilter-Calc"{ trigger OnRun() begin end; var AccountingPeriod: Record "Accounting Period"; StartDate: Date;#pragma warning disable AA0074#pragma warning disable AA0470 Text000: Label 'Fiscal Year %1';#pragma warning restore AA0470#pragma warning restore AA0074 procedure CreateFiscalYearFilter(var "Filter": Text[30]; var Name: Text[30]; Date: Date; NextStep: Integer) begin CreateAccountingDateFilter(Filter, Name, true, Date, NextStep); end; procedure CreateAccountingPeriodFilter(var "Filter": Text[30]; var Name: Text[30]; Date: Date; NextStep: Integer) begin CreateAccountingDateFilter(Filter, Name, false, Date, NextStep); end; procedure ConvertToUtcDateTime(DateTimeSource: DateTime): DateTime var DotNetDateTimeOffsetSource: DotNet DateTimeOffset; DotNetDateTimeOffsetNow: DotNet DateTimeOffset; begin if DateTimeSource = CreateDateTime(0D, 0T) then exit(CreateDateTime(0D, 0T)); DotNetDateTimeOffsetSource := DotNetDateTimeOffsetSource.DateTimeOffset(DateTimeSource); DotNetDateTimeOffsetNow := DotNetDateTimeOffsetNow.Now; exit(DotNetDateTimeOffsetSource.LocalDateTime - DotNetDateTimeOffsetNow.Offset); end; local procedure CreateAccountingDateFilter(var "Filter": Text[30]; var Name: Text[30]; FiscalYear: Boolean; Date: Date; NextStep: Integer) begin AccountingPeriod.Reset(); if FiscalYear then AccountingPeriod.SetRange("New Fiscal Year", true); AccountingPeriod."Starting Date" := Date; if not AccountingPeriod.Find('=<>') then exit; if AccountingPeriod."Starting Date" > Date then NextStep := NextStep - 1; if NextStep <> 0 then if AccountingPeriod.Next(NextStep) <> NextStep then begin if NextStep < 0 then Filter := '..' + Format(AccountingPeriod."Starting Date" - 1) else Filter := Format(AccountingPeriod."Starting Date") + '..' + Format(DMY2Date(31, 12, 9999)); Name := '...'; exit; end; StartDate := AccountingPeriod."Starting Date"; if FiscalYear then Name := StrSubstNo(Text000, Format(Date2DMY(StartDate, 3))) else Name := AccountingPeriod.Name; if AccountingPeriod.Next() <> 0 then Filter := Format(StartDate) + '..' + Format(AccountingPeriod."Starting Date" - 1) else begin Filter := Format(StartDate) + '..' + Format(DMY2Date(31, 12, 9999)); Name := Name + '...'; end; end;}